Execution Plan ---------------------------------------------------------- Plan hash value: 1268268161 -------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop | -------------------------------------------------------------------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | 4 | 580 | 143 (52)| 00:00:02 | | | | 1 | SORT UNIQUE | | 4 | 580 | 143 (52)| 00:00:02 | | | | 2 | UNION-ALL | | | | | | | | | 3 | NESTED LOOPS OUTER | | 2 | 290 | 70 (0)| 00:00:01 | | | | 4 | NESTED LOOPS OUTER | | 2 | 218 | 26 (0)| 00:00:01 | | | | 5 | NESTED LOOPS | | 2 | 120 | 14 (0)| 00:00:01 | | | | 6 | NESTED LOOPS | | 2 | 68 | 8 (0)| 00:00:01 | | | | 7 | PARTITION LIST ALL | | 2 | 36 | 4 (0)| 00:00:01 | 1 | 2 | | 8 | TABLE ACCESS BY LOCAL INDEX ROWID| CUSTOMER_RELATIONSHIP | 2 | 36 | 4 (0)| 00:00:01 | 1 | 2 | |* 9 | INDEX RANGE SCAN | CUSTOMER_RELATIONSHIP_IX2 | 2 | | 3 (0)| 00:00:01 | 1 | 2 | |* 10 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 16 | 1 (0)| 00:00:01 | | | | 11 | PARTITION LIST ALL | | 1 | 26 | 3 (0)| 00:00:01 | 1 | 2 | | 12 | TABLE ACCESS BY LOCAL INDEX ROWID | CUSTOMER_INDIVIDUAL | 1 | 26 | 3 (0)| 00:00:01 | 1 | 2 | |* 13 | INDEX RANGE SCAN | CUSTOMER_INDIVIDUAL_IX2 | 1 | | 2 (0)| 00:00:01 | 1 | 2 | | 14 | VIEW PUSHED PREDICATE | | 1 | 49 | 6 (0)| 00:00:01 | | | | 15 | TABLE ACCESS BY INDEX ROWID | BILLING_ACCOUNT_EXT | 1 | 10 | 2 (0)| 00:00:01 | | | | 16 | NESTED LOOPS | | 1 | 39 | 6 (0)| 00:00:01 | | | | 17 | NESTED LOOPS | | 1 | 29 | 4 (0)| 00:00:01 | | | |* 18 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 6 | 2 (0)| 00:00:01 | | | | 19 | TABLE ACCESS BY INDEX ROWID | BILLING_ACCOUNT | 1 | 23 | 2 (0)| 00:00:01 | | | |* 20 | INDEX RANGE SCAN | BILLING_ACCOUNT_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 21 | INDEX RANGE SCAN | BILLING_ACCOUNT_EXT_IX1 | 1 | | 1 (0)| 00:00:01 | | | | 22 | VIEW PUSHED PREDICATE | | 1 | 36 | 22 (0)| 00:00:01 | | | |* 23 | TABLE ACCESS BY INDEX ROWID | SERVICE_INSTANCE | 1 | 24 | 16 (0)| 00:00:01 | | | | 24 | NESTED LOOPS | | 1 | 64 | 22 (0)| 00:00:01 | | | | 25 | NESTED LOOPS | | 1 | 40 | 6 (0)| 00:00:01 | | | | 26 | NESTED LOOPS | | 1 | 26 | 4 (0)| 00:00:01 | | | |* 27 | INDEX UNIQUE SCAN | BILLING_ACCOUNT_PK | 1 | | 1 (0)| 00:00:01 | | | |* 28 | TABLE ACCESS BY INDEX ROWID | BILLING_ARRANGEMENT | 1 | 14 | 2 (0)| 00:00:01 | | | |* 29 | INDEX RANGE SCAN | BILLING_ARRANGEMENT_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 30 | TABLE ACCESS BY INDEX ROWID | PAY_CHANNEL | 1 | 14 | 2 (0)| 00:00:01 | | | |* 31 | INDEX RANGE SCAN | PAY_CHANNEL_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 32 | INDEX RANGE SCAN | SERVICE_INSTANCE_IX3 | 22 | | 1 (0)| 00:00:01 | | | | 33 | NESTED LOOPS OUTER | | 2 | 290 | 71 (0)| 00:00:01 | | | | 34 | NESTED LOOPS OUTER | | 2 | 218 | 27 (0)| 00:00:01 | | | | 35 | NESTED LOOPS | | 2 | 120 | 15 (0)| 00:00:01 | | | | 36 | NESTED LOOPS | | 2 | 68 | 9 (0)| 00:00:01 | | | | 37 | PARTITION LIST ALL | | 2 | 36 | 5 (0)| 00:00:01 | 1 | 2 | | 38 | TABLE ACCESS BY LOCAL INDEX ROWID| CUSTOMER_RELATIONSHIP | 2 | 36 | 5 (0)| 00:00:01 | 1 | 2 | |* 39 | INDEX RANGE SCAN | CUSTOMER_RELATIONSHIP_IX1 | 2 | | 3 (0)| 00:00:01 | 1 | 2 | |* 40 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 16 | 1 (0)| 00:00:01 | | | | 41 | PARTITION LIST ALL | | 1 | 26 | 3 (0)| 00:00:01 | 1 | 2 | | 42 | TABLE ACCESS BY LOCAL INDEX ROWID | CUSTOMER_INDIVIDUAL | 1 | 26 | 3 (0)| 00:00:01 | 1 | 2 | |* 43 | INDEX RANGE SCAN | CUSTOMER_INDIVIDUAL_IX2 | 1 | | 2 (0)| 00:00:01 | 1 | 2 | | 44 | VIEW PUSHED PREDICATE | | 1 | 49 | 6 (0)| 00:00:01 | | | | 45 | TABLE ACCESS BY INDEX ROWID | BILLING_ACCOUNT_EXT | 1 | 10 | 2 (0)| 00:00:01 | | | | 46 | NESTED LOOPS | | 1 | 39 | 6 (0)| 00:00:01 | | | | 47 | NESTED LOOPS | | 1 | 29 | 4 (0)| 00:00:01 | | | |* 48 | INDEX UNIQUE SCAN | CUSTOMER_PK | 1 | 6 | 2 (0)| 00:00:01 | | | | 49 | TABLE ACCESS BY INDEX ROWID | BILLING_ACCOUNT | 1 | 23 | 2 (0)| 00:00:01 | | | |* 50 | INDEX RANGE SCAN | BILLING_ACCOUNT_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 51 | INDEX RANGE SCAN | BILLING_ACCOUNT_EXT_IX1 | 1 | | 1 (0)| 00:00:01 | | | | 52 | VIEW PUSHED PREDICATE | | 1 | 36 | 22 (0)| 00:00:01 | | | |* 53 | TABLE ACCESS BY INDEX ROWID | SERVICE_INSTANCE | 1 | 24 | 16 (0)| 00:00:01 | | | | 54 | NESTED LOOPS | | 1 | 64 | 22 (0)| 00:00:01 | | | | 55 | NESTED LOOPS | | 1 | 40 | 6 (0)| 00:00:01 | | | | 56 | NESTED LOOPS | | 1 | 26 | 4 (0)| 00:00:01 | | | |* 57 | INDEX UNIQUE SCAN | BILLING_ACCOUNT_PK | 1 | | 1 (0)| 00:00:01 | | | |* 58 | TABLE ACCESS BY INDEX ROWID | BILLING_ARRANGEMENT | 1 | 14 | 2 (0)| 00:00:01 | | | |* 59 | INDEX RANGE SCAN | BILLING_ARRANGEMENT_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 60 | TABLE ACCESS BY INDEX ROWID | PAY_CHANNEL | 1 | 14 | 2 (0)| 00:00:01 | | | |* 61 | INDEX RANGE SCAN | PAY_CHANNEL_IX1 | 1 | | 1 (0)| 00:00:01 | | | |* 62 | INDEX RANGE SCAN | SERVICE_INSTANCE_IX3 | 22 | | 1 (0)| 00:00:01 | | | -------------------------------------------------------------------------------------------------------------------------------------- Predicate Information (identified by operation id): --------------------------------------------------- 9 - access("CR"."CUSTOMER_ID"=10001311) 10 - access("CR"."RELATED_CUSTOMER_ID"="C"."CUSTOMER_ID") 13 - access("CI"."CUSTOMER_ID"="C"."CUSTOMER_ID") 18 - access("C"."CUSTOMER_ID"="C"."CUSTOMER_ID") 20 - access("BA"."CUSTOMER_ID"="C"."CUSTOMER_ID") 21 - access("BAE"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 23 - filter("S"."SRVC_INSTNC_STAT_CD"='A') 27 - access("BA"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 28 - filter("A"."BILLING_ARRNGMT_STATUS_CD"='O') 29 - access("A"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 30 - filter("P"."PAY_CHNL_STATUS_CD"='O') 31 - access("A"."BILLING_ARRANGEMENT_ID"="P"."BILLING_ARRANGEMENT_ID") 32 - access("P"."PAY_CHANNEL_ID"="S"."DFLT_RC_PAY_CHANNEL_ID") filter("S"."DFLT_RC_PAY_CHANNEL_ID" IS NOT NULL) 39 - access("CR"."RELATED_CUSTOMER_ID"=57576218) 40 - access("CR"."CUSTOMER_ID"="C"."CUSTOMER_ID") 43 - access("CI"."CUSTOMER_ID"="C"."CUSTOMER_ID") 48 - access("C"."CUSTOMER_ID"="C"."CUSTOMER_ID") 50 - access("BA"."CUSTOMER_ID"="C"."CUSTOMER_ID") 51 - access("BAE"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 53 - filter("S"."SRVC_INSTNC_STAT_CD"='A') 57 - access("BA"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 58 - filter("A"."BILLING_ARRNGMT_STATUS_CD"='O') 59 - access("A"."BILLING_ACCOUNT_ID"="BA"."BILLING_ACCOUNT_ID") 60 - filter("P"."PAY_CHNL_STATUS_CD"='O') 61 - access("A"."BILLING_ARRANGEMENT_ID"="P"."BILLING_ARRANGEMENT_ID") 62 - access("P"."PAY_CHANNEL_ID"="S"."DFLT_RC_PAY_CHANNEL_ID") filter("S"."DFLT_RC_PAY_CHANNEL_ID" IS NOT NULL) Statistics ---------------------------------------------------------- 0 recursive calls 0 db block gets 114 consistent gets 31 physical reads 0 redo size 1740 bytes sent via SQL*Net to client 5284 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 6 rows processed