PLAN_TABLE_OUTPUT -------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost | -------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 50 | | 22 | | 2 | TEMP TABLE TRANSFORMATION | | | | | | | 1 | RECURSIVE EXECUTION | SYS_LE_2_0 | | | | | | 0 | INSERT STATEMENT | | 3053 | 128K| | 1372 | | 1 | LOAD AS SELECT | | | | | | | 2 | SORT UNIQUE | | 3053 | 128K| 376K| 1372 | | 3 | UNION-ALL | | | | | | |* 4 | HASH JOIN | | 3052 | 128K| | 185 | |* 5 | TABLE ACCESS FULL | EES_CONS_PROV | 622 | 3732 | | 2 | |* 6 | TABLE ACCESS BY INDEX ROWID | EES_ENERGY_MASTER | 3055 | 110K| | 182 | |* 7 | INDEX RANGE SCAN | IDX_ENERGY_PDCT_CAT | 1978 | | | 2478 | | 8 | SORT GROUP BY | | 1 | 40 | | 1160 | |* 9 | TABLE ACCESS BY INDEX ROWID | EES_HOSP_CHG_PROV | 4 | 72 | | 1 | | 10 | NESTED LOOPS | | 1 | 40 | | 1157 | | 11 | NESTED LOOPS | | 1 | 22 | | 1156 | |* 12 | TABLE ACCESS BY INDEX ROWID| MVW_EES_ICD_STATS | 1 | 16 | | 1155 | |* 13 | INDEX RANGE SCAN | MVWICDSTATS_DISCQTR_IDX | 13M| | | 26068 | |* 14 | TABLE ACCESS BY INDEX ROWID| EES_CONS_PROV | 1 | 6 | | 1 | |* 15 | INDEX UNIQUE SCAN | EES_CONS_PROV_PK | 1 | | | | |* 16 | INDEX RANGE SCAN | PROV_ID_IDX_2 | 65 | | | 1 | | 3 | MERGE JOIN CARTESIAN | | 1 | 50 | | 22 | | 4 | VIEW | | 1 | 13 | | 3 | | 5 | SORT GROUP BY | | 1 | 13 | | | | 6 | VIEW | | 3053 | 39689 | | 3 | | 7 | TABLE ACCESS FULL | SYS_TEMP_0FD9D68B3_C112F95D | 3053 | 110K| | 3 | | 8 | VIEW | | 1 | 37 | | 19 | | 9 | SORT GROUP BY | | 1 | 37 | | 19 | | 10 | VIEW | | 3053 | 110K| | 3 | | 11 | TABLE ACCESS FULL | SYS_TEMP_0FD9D68B3_C112F95D | 3053 | 110K| | 3 | -------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 4 - access("EES_ENERGY_MASTER"."PROV_ID"="EES_CONS_PROV"."PROV_ID") 5 - filter("EES_CONS_PROV"."CONS_06_09_YN"='N' OR "EES_CONS_PROV"."CONS_06_09_YN"='Y') 6 - filter("EES_ENERGY_MASTER"."DISC_MON">=2006101 AND SUBSTR("EES_ENERGY_MASTER"."ICD_CODE",1,2)='68-gyn' AND "EES_ENERGY_MASTER"."MANUFACTURER"='EES') 7 - access("EES_ENERGY_MASTER"."PDCT_CAT"='Energy') 9 - filter("EES_HOSP_CHG_PROV"."PDCT_CAT"='Energy' AND "EES_HOSP_CHG_PROV"."MANUFACTURER"='EES') 12 - filter("MVW_EES_ICD_STATS"."ICD_GROUP"='68-gyn') 13 - access("MVW_EES_ICD_STATS"."DISC_QTR">=20061 AND "MVW_EES_ICD_STATS"."DISC_QTR" IS NOT NULL) 14 - filter("EES_CONS_PROV"."CONS_06_09_YN"='N' OR "EES_CONS_PROV"."CONS_06_09_YN"='Y') 15 - access("MVW_EES_ICD_STATS"."PROV_ID"="EES_CONS_PROV"."PROV_ID") 16 - access("MVW_EES_ICD_STATS"."PROV_ID"="EES_HOSP_CHG_PROV"."PROV_ID") Note: cpu costing is off