Explain plan for SELECT DATETIME, elements_target elements, ROUND(SUM(nds_pm_kpi0),20) AS nds_pm_kpi0, COUNT(*) element_count FROM (SELECT DATETIME, RNC as elements_target, ROUND(PERCENT(pmTotNoRrcConnectReqCsSucc,pmTotNoRrcConnectReqCs)*DIV(pmNoRabEstablishSuccessSpeech,pmNoRabEstablishAttemptSpeech-pmNoDirRetryAtt)*DIV(pmNoNormalRabReleaseSpeech,pmNoRabEstablishSuccessSpeech),2) AS nds_pm_kpi0 FROM (SELECT DATETIME AS DATETIME, RNC, SUM(pmTotNoRrcConnectReqCsSucc) AS pmTotNoRrcConnectReqCsSucc, SUM(pmTotNoRrcConnectReqCs) AS pmTotNoRrcConnectReqCs, SUM(pmNoRabEstablishSuccessSpeech) AS pmNoRabEstablishSuccessSpeech, SUM(pmNoRabEstablishAttemptSpeech) AS pmNoRabEstablishAttemptSpeech, SUM(pmNoDirRetryAtt) AS pmNoDirRetryAtt, SUM(pmNoNormalRabReleaseSpeech) AS pmNoNormalRabReleaseSpeech FROM ERICSSON_UTRAN.RNC_UCELL WHERE DATETIME BETWEEN to_date('30/07/2012 07:39:00','DD/MM/YYYY HH24:MI:SS') AND to_date('02/08/2012 17:44:59','DD/MM/YYYY HH24:MI:SS') and RNC='ErU_RNC_2' GROUP BY DATETIME, RNC ) r1 ) GROUP BY DATETIME, elements_target SELECT * FROM TABLE(DBMS_XPLAN.display); PLAN_TABLE_OUTPUT Plan hash value: 155708868 ---------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | ---------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 167 | 5344 | 334K (1)| 01:17:58 | | | | 1 | HASH GROUP BY | | 167 | 5344 | 334K (1)| 01:17:58 | | | | 2 | PARTITION RANGE ITERATOR | | 235 | 7520 | 334K (1)| 01:17:58 | 3 | 6 | | 3 | VIEW | | 235 | 7520 | 334K (1)| 01:17:58 | | | | 4 | HASH GROUP BY | | 235 | 35250 | 334K (1)| 01:17:58 | | | | 5 | TABLE ACCESS BY LOCAL INDEX ROWID| RNC_UCELL | 330K| 47M| 334K (1)| 01:17:57 | 3 | 6 | |* 6 | INDEX RANGE SCAN | RNC_UCELL_PK | 165K| | 2875 (1)| 00:00:41 | 3 | 6 | ---------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 6 - access("RNC"='ErU_RNC_2' AND "DATETIME">=TO_DATE(' 2012-07-30 07:39:00', 'syyyy-mm-dd hh24:mi:ss') AND "DATETIME"<=TO_DATE(' 2012-08-02 17:44:59', 'syyyy-mm-dd hh24:mi:ss')) filter("DATETIME"<=TO_DATE(' 2012-08-02 17:44:59', 'syyyy-mm-dd hh24:mi:ss') AND "DATETIME">=TO_DATE(' 2012-07-30 07:39:00', 'syyyy-mm-dd hh24:mi:ss'))