------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | ------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 167K| 29M| | 873K (1)| 02:54:46 | | | | 1 | HASH GROUP BY | | 167K| 29M| 37M| 873K (1)| 02:54:46 | | | |* 2 | FILTER | | | | | | | | | | 3 | NESTED LOOPS OUTER | | 201K| 35M| | 866K (1)| 02:53:19 | | | | 4 | NESTED LOOPS | | 201K| 34M| | 811K (1)| 02:42:22 | | | | 5 | NESTED LOOPS | | 201K| 28M| | 731K (1)| 02:26:13 | | | | 6 | NESTED LOOPS | | 55622 | 6844K| | 263K (1)| 00:52:44 | | | |* 7 | HASH JOIN | | 1576 | 121K| | 36 (3)| 00:00:01 | | | | 8 | TABLE ACCESS FULL | PHU_ALL_STORES_CURRENCY_322 | 7190 | 407K| | 17 (0)| 00:00:01 | | | |* 9 | TABLE ACCESS BY INDEX ROWID | DW_STORE_STATUS | 1576 | 33096 | | 18 (0)| 00:00:01 | | | |* 10 | INDEX RANGE SCAN | DW_STORE_STATUS_X1 | 7427 | | | 8 (0)| 00:00:01 | | | | 11 | PARTITION RANGE ITERATOR | | 35 | 1645 | | 167 (0)| 00:00:03 | KEY | KEY | |* 12 | TABLE ACCESS BY LOCAL INDEX ROWID| AV_TRANSACTION_HEADER | 35 | 1645 | | 167 (0)| 00:00:03 | KEY | KEY | |* 13 | INDEX RANGE SCAN | AV_TRANSACTION_HEADER_X0 | 192 | | | 1 (0)| 00:00:01 | KEY | KEY | | 14 | PARTITION RANGE ALL | | 4 | 96 | | 8 (0)| 00:00:01 | 1 | 23 | |* 15 | TABLE ACCESS BY LOCAL INDEX ROWID | AV_DISCOUNT_DETAIL | 4 | 96 | | 8 (0)| 00:00:01 | 1 | 23 | |* 16 | INDEX RANGE SCAN | AV_DISCOUNT_DETAIL_X0 | 5 | | | 8 (0)| 00:00:01 | 1 | 23 | |* 17 | TABLE ACCESS BY GLOBAL INDEX ROWID | AV_TRANSACTION_LINE | 1 | 31 | | 1 (0)| 00:00:01 | ROWID | ROWID | |* 18 | INDEX RANGE SCAN | AV_TRANSACTION_LINE_X0 | 1 | | | 1 (0)| 00:00:01 | | | | 19 | VIEW | | 1 | 3 | | 0 (0)| 00:00:01 | | | |* 20 | FILTER | | | | | | | | | |* 21 | TABLE ACCESS BY INDEX ROWID | CURRENCY_CONVERSION | 1 | 19 | | 1 (0)| 00:00:01 | | | |* 22 | INDEX RANGE SCAN | CURRENCY_CONVERSION_X1 | 1 | | | 1 (0)| 00:00:01 | | | ------------------------------------------------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter(TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS')<=TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS')) 7 - access("W"."ORG_CHN_NUM"="DW"."STORE_NO") 9 - filter("DW"."STORE_STATUS">0 AND "DW"."SUBLEDGER_COPIED_FLAG"=0) 10 - access("DW"."SALES_DATE">=TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS') AND "DW"."SALES_DATE"<=TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS')) 12 - filter(("H"."TRANSACTION_VOID_FLAG"=0 OR "H"."TRANSACTION_VOID_FLAG"=8) AND "H"."DATE_REJECT_ID"=0 AND "H"."SA_REJECTION_FLAG"=0) 13 - access("DW"."SALES_DATE"="H"."TRANSACTION_DATE" AND "DW"."STORE_NO"="H"."STORE_NO") filter("H"."TRANSACTION_DATE"<=TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS') AND "H"."TRANSACTION_DATE">=TO_DATE('2010-01-17','YYYY-MM-DD HH24:MI:SS')) 15 - filter("D"."APPLIED_FLAG"=1) 16 - access("H"."AV_TRANSACTION_ID"="D"."AV_TRANSACTION_ID") 17 - filter("TL"."DB_CR_NONE"<>0 AND "TL"."LINE_VOID_FLAG"=0) 18 - access("D"."AV_TRANSACTION_ID"="TL"."AV_TRANSACTION_ID" AND "D"."LINE_ID"="TL"."LINE_ID") 20 - filter(NULL IS NOT NULL) 21 - filter("V"."EFFECTIVE_DATE_TO" IS NULL OR "V"."EFFECTIVE_DATE_TO">="H"."TRANSACTION_DATE") 22 - access("W"."CURRENCY_ID"="V"."CURRENCY_ID" AND "V"."CURRENCY_CONVERSION_TYPE_ID"=1 AND "V"."EFFECTIVE_DATE_FROM"<="H"."TRANSACTION_DATE") filter("W"."CURRENCY_ID"="V"."CURRENCY_ID" AND "V"."CURRENCY_CONVERSION_TYPE_ID"=1) Note ----- - dynamic sampling used for this statement