PLAN_TABLE_OUTPUT ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost | Pstart| Pstop | ---------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 405 | 25464 | | | | 1 | SORT GROUP BY | | 1 | 405 | 25464 | | | |* 2 | HASH JOIN | | 1 | 405 | 25458 | | | |* 3 | HASH JOIN | | 1 | 345 | 25262 | | | |* 4 | HASH JOIN | | 1 | 336 | 25253 | | | |* 5 | HASH JOIN | | 1 | 284 | 25057 | | | |* 6 | TABLE ACCESS FULL | DIM_TM_MV | 1 | 52 | 195 | | | | 7 | PARTITION RANGE ALL | | | | | 1 | 9 | | 8 | PARTITION LIST ALL | | | | | 1 | 12 | | 9 | TABLE ACCESS BY LOCAL INDEX ROWID| FACT_DLY_ALGND_SLS | 15M| 3502M| 24632 | 1 | 1 | 10 | BITMAP CONVERSION TO ROWIDS | | | | | | | | 11 | BITMAP INDEX FULL SCAN | XN1_FACT_DLY_SLS | | | | 1 | 108 | |* 12 | TABLE ACCESS FULL | DIM_TM_MV | 1 | 52 | 195 | | | | 13 | VIEW | VW_NSO_1 | 6 | 54 | 8 | | | | 14 | SORT UNIQUE | | 6 | 42 | 8 | | | | 15 | TABLE ACCESS FULL | FACT_MLY_PART_TRUNC | 6 | 42 | 2 | | | | 16 | TABLE ACCESS FULL | DIM_TM_MV | 15255 | 893K| 195 | | | ---------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 2 - access("F"."COMP_DT_BE_ID"="COMP_TM"."BE_ID") 3 - access("VW_NSO_1"."YR_MO"=TO_CHAR("F"."PRD_YR_CD")||'_'||LPAD(TO_CHAR("F"."PRD_MO_CD"),2,'0') 4 - access("F"."INVC_DT"="INVC_TM"."DAY_STRT_PRD_OF_TM") 5 - access("F"."TRANSACTION_DATE"="TRANS_TM"."DAY_STRT_PRD_OF_TM") 6 - filter("TRANS_TM"."DAY_STRT_PRD_OF_TM" IS NOT NULL AND "TRANS_TM"."DAY_OID"="TRANS_TM"."BE_ID 12 - filter("INVC_TM"."DAY_STRT_PRD_OF_TM" IS NOT NULL AND "INVC_TM"."DAY_OID"="INVC_TM"."BE_ID")