why is super sume pro is taking a long time

(SELECT DISTINCT c.TRANSACTIONID,d.received_date FROM pai_valid_accrual c, pai_file d (SELECT b.ffpprogram,b.OPERATINGAIRLINECODE,B.ACCRUALPOSTINGSTATUS,b.FFPMEMBERNUMBER (SELECT Nvl(tierlevel,0) FROM pcd_profile WHERE SubStr(FFPNUMBER,4) = resp.FFPMEMBERNUMBER AND airlinecode=resp.ffpprogram AND actioncode 'D') (SELECT ffpprogram ,OPERATINGAIRLINECODE,ACCRUALPOSTINGSTATUS,ĬASE WHEN (prof.tierlevel IS NULL AND ffpprogram = 'SK') THEN Sum(RET_APPROVED_GOLD) RET_APPROVED_GOLD,Sum(RET_APPROVED_SILVER) RET_APPROVED_SILVER,Sum(RET_APPROVED_MISC) RET_APPROVED_MISCĬASE WHEN (ACCRUALPOSTINGSTATUS IN ('01','03') AND tier_level =1) THEN 1 ELSE 0 END ACC_APPROVED_GOLD,ĬASE WHEN (ACCRUALPOSTINGSTATUS IN ('01','03') AND tier_level =2) THEN 1 ELSE 0 END ACC_APPROVED_SILVER,ĬASE WHEN (ACCRUALPOSTINGSTATUS IN ('01','03') AND tier_level IS NULL ) THEN 1 ELSE 0 END ACC_APPROVED_MISC,Ġ AS RET_APPROVED_GOLD,0 AS RET_APPROVED_SILVER, 0 AS RET_APPROVED_MISC SELECT ope,ffp,Sum(ACC_APPROVED_GOLD) ACC_APPROVED_GOLD,Sum(ACC_APPROVED_SILVER) ACC_APPROVED_SILVER,Sum(ACC_APPROVED_MISC) ACC_APPROVED_MISC, The query execution takes long time (more than a hour) and it haven't completed its execution even for one time. I'm trying to generate a report using a query which have aggregate functions involved.

Why is super sume pro is taking a long time