Execution Plan ---------------------------------------------------------- Plan hash value: 2253635241 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 1 | 235 | 16 (7)| 00:00:01 | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10001 | 1 | 235 | 16 (7)| 00:00:01 | | | Q1,01 | P->S | QC (RAND) | | 3 | HASH UNIQUE | | 1 | 235 | 16 (7)| 00:00:01 | | | Q1,01 | PCWP | | | 4 | PX RECEIVE | | 1 | 235 | 15 (0)| 00:00:01 | | | Q1,01 | PCWP | | | 5 | PX SEND HASH | :TQ10000 | 1 | 235 | 15 (0)| 00:00:01 | | | Q1,00 | P->P | HASH | | 6 | NESTED LOOPS | | 1 | 235 | 15 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 7 | NESTED LOOPS OUTER | | 1 | 229 | 14 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 8 | NESTED LOOPS OUTER | | 1 | 216 | 14 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 9 | NESTED LOOPS | | 1 | 189 | 13 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 10 | NESTED LOOPS | | 1 | 150 | 8 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 11 | NESTED LOOPS OUTER | | 1 | 125 | 8 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 12 | NESTED LOOPS | | 1 | 110 | 7 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 13 | NESTED LOOPS | | 1 | 82 | 7 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 14 | PX PARTITION HASH ALL | | 1 | 56 | 6 (0)| 00:00:01 | 1 | 10 | Q1,00 | PCWC | | |* 15 | TABLE ACCESS BY LOCAL INDEX ROWID| ASSET | 1 | 56 | 6 (0)| 00:00:01 | 1 | 10 | Q1,00 | PCWP | | |* 16 | INDEX RANGE SCAN | I_ASSET9_OLD1 | 1 | | 6 (0)| 00:00:01 | 1 | 10 | Q1,00 | PCWP | | |* 17 | INDEX RANGE SCAN | SYS_C0054120 | 1 | 26 | 1 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 18 | INDEX RANGE SCAN | SYS_C0054149 | 1 | 28 | 1 (0)| 00:00:01 | | | Q1,00 | PCWP | | | 19 | PARTITION HASH ALL | | 1 | 15 | 1 (0)| 00:00:01 | 1 | 6 | Q1,00 | PCWP | | |* 20 | INDEX RANGE SCAN | SYS_C00252039 | 1 | 15 | 1 (0)| 00:00:01 | 1 | 6 | Q1,00 | PCWP | | | 21 | TABLE ACCESS BY INDEX ROWID | CUSTOMER | 1 | 25 | 1 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 22 | INDEX UNIQUE SCAN | SYS_C0054289 | 1 | | 0 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 23 | TABLE ACCESS BY INDEX ROWID | X_COV_INSTALLATION_DETAILS | 1 | 39 | 18 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 24 | INDEX RANGE SCAN | I_COV_INST_DET_LE3 | 16 | | 2 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 25 | INDEX RANGE SCAN | SYS_C0054292 | 1 | 27 | 1 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 26 | INDEX UNIQUE SCAN | SYS_C00141773 | 1 | 13 | 1 (0)| 00:00:01 | | | Q1,00 | PCWP | | |* 27 | INDEX RANGE SCAN | I_X_CORP_VWR_REF1 | 1 | 6 | 2 (0)| 00:00:01 | | | Q1,00 | PCWP | | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 15 - filter("T31551"."PRODUCT_KEY"='Private Circuit' AND ("T31551"."CONTRACT_END_DATE" IS NULL OR "T31551"."CONTRACT_END_DATE">TO_DATE('2008-05-06 06:30:27', 'yyyy-mm-dd hh24:mi:ss'))) 16 - access("T31551"."PR_SOURCE_SYSTEM"='COS') 17 - access("T31551"."ASSET_KEY"="T49176"."ASSET_KEY") 18 - access("BCREL"."BILL_ACCNT_KEY"="T49176"."BILL_ACCNT_KEY") 20 - access("BCREL"."BILL_ACCNT_KEY"="BPRO"."BILL_ACCNT_KEY"(+)) 22 - access("CUST"."CUSTOMER_KEY"="BCREL"."CUSTOMER_KEY") 23 - filter("T10573"."SALES_ACCT_ID"='3049W') 24 - access("CUST"."LE_CODE"="T10573"."CV_LE_CODE") 25 - access("CUST"."CUSTOMER_KEY"="CUSADD"."CUSTOMER_KEY"(+)) 26 - access("ADDR"."ADDRESS_KEY"(+)="CUSADD"."ADDRESS_KEY") 27 - access("T7016"."SAC_CODE"="T10573"."SALES_ACCT_ID") filter("T7016"."SAC_CODE"='3049W')