| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert-Select much slower than same select on its own
Hi,
I'm not familiar with dbms_xplan and it's giving me an error so here're the plans straight from Toad. Apols if they turn out to be unreadable (I'll see if I can get them from dbms):
The "good" select plan
Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
SELECT STATEMENT Hint=HINT: ALL_ROWS 1 197
SEQUENCE SVC_C_SS_QUOTE_LINE_ITEM_ID
NESTED LOOPS 1 264 197
NESTED LOOPS 1 244 196
HASH JOIN 1 241 195
HASH JOIN OUTER 1 184 91
VIEW 1 129 22
NESTED LOOPS 1 106 22
NESTED LOOPS 1 99 21
NESTED LOOPS 1 92 20
NESTED LOOPS 1 88 19
NESTED LOOPS 1 75 18
NESTED LOOPS 2 136 17
NESTED LOOPS OUTER 2 112 16
HASH JOIN 2 100 15
HASH JOIN 60 1 K 5
VIEW SVC_QUOTE_PROD_LINE_CODES_ALL 60
1 K 2
UNION-ALL
NESTED LOOPS 1 K 23 K 6
HASH JOIN 1 K 19 K 5
TABLE ACCESS
FULL SVC_QUOTE_PROD_LINE_CODES_SOM 1 K 10 K 2
TABLE ACCESS FULL SVC_PELM 4
K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
NESTED LOOPS 1 K 23 K 6
HASH JOIN 1 K 19 K 5
TABLE ACCESS
FULL SVC_QUOTE_PROD_LINE_CODES_HOM 1 K 10 K 2
TABLE ACCESS FULL SVC_PELM 4
K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
TABLE ACCESS FULL SVC_PELM 4 K 32 K 2
VIEW 54 1 K 9
HASH JOIN 54 2 K 9
MERGE JOIN CARTESIAN 34 986 6
MERGE JOIN CARTESIAN 3 75 5
MERGE JOIN CARTESIAN 2 46 4
NESTED LOOPS 1 16 2
TABLE ACCESS BY INDEX
ROWID SVC_QUOTES 1 6 1
INDEX UNIQUE
SCAN PK_SVC_QUOTES 1 1
TABLE ACCESS BY INDEX
ROWID DISTRIBUTOR 1 10 1
INDEX RANGE
SCAN DISTRIBUTOR_IDX_017 1 1
BUFFER SORT 2 14 3
TABLE ACCESS
FULL SVC_QUOTE_EQUIP_LOC 2 14 2
BUFFER SORT 2 4 3
INDEX FULL
SCAN PK_SVC_SERVICE_TYPES 2 4 1
BUFFER SORT 11 44 5
INDEX FULL
SCAN PK_SVC_CEANTAR_GPPC_REGION_MAP 11 44 1
TABLE ACCESS FULL CUSTOMERMASTER 1
K 20 K 2
VIEW PUSHED
PREDICATE SVC_GEO_MAX_AVAILABILITY 1 6 1
HASH JOIN SEMI 4 224 11
HASH JOIN 40 1 K 6
MERGE JOIN CARTESIAN 35 350 3
TABLE ACCESS BY INDEX
ROWID SVC_SERVICE_TYPES 1 4 1
INDEX UNIQUE
SCAN PK_SVC_SERVICE_TYPES 1
TABLE ACCESS FULL SVC_ROOTS 35
210 2
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 2 K 2
VIEW VW_NSO_2 32 960 4
SORT GROUP BY 32 320 4
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 1 K 2
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_LINE_ITEMS 1 12 1
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
TABLE ACCESS BY INDEX
ROWID SVC_ROOT_REGION_MAP 1 7 1
INDEX RANGE
SCAN IX_SVC_ROOT_REGION_MAP_ROOT 2
TABLE ACCESS BY INDEX ROWID SVC_ROOTS 1 13 1
INDEX UNIQUE SCAN PK_SVC_ROOTS 1
INDEX UNIQUE SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 1 4
TABLE ACCESS BY INDEX ROWID SVC_ROOT_REGION_MAP 1 7
1
INDEX RANGE SCAN IX_SVC_ROOT_REGION_MAP_SEQ 5 1
TABLE ACCESS BY INDEX ROWID SVC_ROOTS 1 7 1
INDEX UNIQUE SCAN PK_SVC_ROOTS 1
VIEW SVC_CB_PECS_FOR_PLG 1 55 68
SORT UNIQUE 1 54 68
TABLE ACCESS BY INDEX ROWID SVC_QUOTE_LINE_ITEMS 2 8
1
NESTED LOOPS 1 54 66
NESTED LOOPS 1 50 65
NESTED LOOPS 1 46 64
NESTED LOOPS 1 38 63
NESTED LOOPS 1 27 62
NESTED LOOPS 1 24 61
VIEW 1 18 60
SORT GROUP BY 1 19 60
NESTED LOOPS 1 19 58
NESTED LOOPS 1 13 57
MERGE JOIN CARTESIAN 1 9 56
TABLE ACCESS
FULL SVC_QUOTE_LINE_ITEMS 1 7 55
BUFFER SORT 2 4 1
INDEX FULL
SCAN PK_SVC_COUNT_BASED_PLGS 2 4 1
INDEX UNIQUE
SCAN PK_SVC_CB_PLG_TYPES_MAP 1 4
TABLE ACCESS BY INDEX
ROWID SVC_PELM 1 6 1
INDEX UNIQUE SCAN PK_SVC_PELM 1
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_EQUIP_LOC 1 6 1
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1
INDEX UNIQUE SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX
ROWID SVC_COUNT_BASED_PLGS 1 11 1
INDEX UNIQUE SCAN PK_SVC_COUNT_BASED_PLGS 1
TABLE ACCESS BY INDEX ROWID SVC_PELM 1 8 1
INDEX RANGE SCAN IX_SVC_PELM_QEL_ID 2
INDEX RANGE SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 2 8
1
INDEX RANGE SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
VIEW 1 57 103
SORT GROUP BY 1 145 103
HASH JOIN 1 145 101
HASH JOIN 2 262 98
TABLE ACCESS BY INDEX ROWID PARTREGIONLISTPRICE 2
96 1
NESTED LOOPS 2 256 95
NESTED LOOPS 1 80 94
NESTED LOOPS 1 77 93
FILTER
HASH JOIN OUTER
NESTED LOOPS 1 52 23
TABLE ACCESS BY INDEX
ROWID SVC_QUOTES 1 6 1
INDEX UNIQUE SCAN PK_SVC_QUOTES 1
1
VIEW 1 46 22
NESTED LOOPS 1 102 22
NESTED LOOPS 1 95 21
NESTED LOOPS 1 88 20
NESTED LOOPS 1 84 19
NESTED LOOPS 1 71 18
NESTED LOOPS 2 128 17
NESTED LOOPS OUTER 2
112 16
HASH JOIN 2 100 15
HASH JOIN 60 1 K 5
VIEW SVC_QUOTE_PROD_LINE_CODES_ALL 60 1 K 2
UNION-ALL
NESTED LOOPS 1
K 23 K 6
HASH JOIN 1
K 19 K 5
TABLE
ACCESS FULL SVC_QUOTE_PROD_LINE_CODES_SOM 1 K 10 K 2
TABLE
ACCESS FULL SVC_PELM 4 K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
NESTED LOOPS 1
K 23 K 6
HASH JOIN 1
K 19 K 5
TABLE
ACCESS FULL SVC_QUOTE_PROD_LINE_CODES_HOM 1 K 10 K 2
TABLE
ACCESS FULL SVC_PELM 4 K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
TABLE ACCESS
FULL SVC_PELM 4 K 32 K 2
VIEW 54 1 K 9
HASH JOIN 54 2
K 9
MERGE JOIN
CARTESIAN 34 986 6
MERGE JOIN
CARTESIAN 3 75 5
MERGE JOIN
CARTESIAN 2 46 4
NESTED
LOOPS 1 16 2
TABLE
ACCESS BY INDEX ROWID SVC_QUOTES 1 6 1
INDEX
UNIQUE SCAN PK_SVC_QUOTES 1 1
TABLE
ACCESS BY INDEX ROWID DISTRIBUTOR 1 10 1
INDEX
RANGE SCAN DISTRIBUTOR_IDX_017 1 1
BUFFER
SORT 2 14 3
TABLE
ACCESS FULL SVC_QUOTE_EQUIP_LOC 2 14 2
BUFFER
SORT 2 4 3
INDEX FULL
SCAN PK_SVC_SERVICE_TYPES 2 4 1
BUFFER SORT 11
44 5
INDEX FULL
SCAN PK_SVC_CEANTAR_GPPC_REGION_MAP 11 44 1
TABLE ACCESS
FULL CUSTOMERMASTER 1 K 20 K 2
VIEW PUSHED
PREDICATE SVC_GEO_MAX_AVAILABILITY 1 6 1
HASH JOIN 3 168
11
HASH JOIN 40 1
K 6
MERGE JOIN
CARTESIAN 35 350 3
TABLE ACCESS BY
INDEX ROWID SVC_SERVICE_TYPES 1 4 1
INDEX UNIQUE
SCAN PK_SVC_SERVICE_TYPES 1
TABLE ACCESS
FULL SVC_ROOTS 35 210 2
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 2 K 2
VIEW VW_NSO_1 32
960 4
SORT GROUP BY 32
320 4
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 1 K 2
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_LINE_ITEMS 1 8 1
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
TABLE ACCESS BY INDEX
ROWID SVC_ROOT_REGION_MAP 1 7 1
INDEX RANGE
SCAN IX_SVC_ROOT_REGION_MAP_ROOT 2
TABLE ACCESS BY INDEX
ROWID SVC_ROOTS 1 13 1
INDEX UNIQUE
SCAN PK_SVC_ROOTS 1
INDEX UNIQUE
SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 1 4
TABLE ACCESS BY INDEX
ROWID SVC_ROOT_REGION_MAP 1 7 1
INDEX RANGE
SCAN IX_SVC_ROOT_REGION_MAP_SEQ 5 1
TABLE ACCESS BY INDEX
ROWID SVC_ROOTS 1 7 1
INDEX UNIQUE SCAN PK_SVC_ROOTS 1
VIEW SVC_CB_PECS_FOR_PLG 1 12 68
SORT UNIQUE 1 54 68
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_LINE_ITEMS 2 8 1
NESTED LOOPS 1 54 66
NESTED LOOPS 1 50 65
NESTED LOOPS 1 46 64
NESTED LOOPS 1 38 63
NESTED LOOPS 1 27 62
NESTED LOOPS 1 24 61
VIEW 1 18 60
SORT GROUP BY 1 19
60
NESTED LOOPS 1
19 58
NESTED LOOPS 1
13 57
MERGE JOIN
CARTESIAN 1 9 56
TABLE ACCESS
FULL SVC_QUOTE_LINE_ITEMS 1 7 55
BUFFER
SORT 2 4 1
INDEX FULL
SCAN PK_SVC_COUNT_BASED_PLGS 2 4 1
INDEX UNIQUE
SCAN PK_SVC_CB_PLG_TYPES_MAP 1 4
TABLE ACCESS BY
INDEX ROWID SVC_PELM 1 6 1
INDEX UNIQUE
SCAN PK_SVC_PELM 1
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_EQUIP_LOC 1 6 1
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1
INDEX UNIQUE
SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX
ROWID SVC_COUNT_BASED_PLGS 1 11 1
INDEX UNIQUE
SCAN PK_SVC_COUNT_BASED_PLGS 1
TABLE ACCESS BY INDEX
ROWID SVC_PELM 1 8 1
INDEX RANGE
SCAN IX_SVC_PELM_QEL_ID 2
INDEX RANGE
SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 2 8 1
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
TABLE ACCESS BY INDEX ROWID DISTRIBUTOR 1
13 1
INDEX RANGE SCAN DISTRIBUTOR_IDX_017 1
1
INDEX UNIQUE SCAN PK_COUNTRY 1 3
INDEX RANGE SCAN PRLP_OCODE 6
TABLE ACCESS FULL MODELCURRENCY 70 210 2
TABLE ACCESS FULL CUSTOMERMASTER 1 K 23 K 2
INDEX UNIQUE SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX ROWID SVC_QUOTE_LINE_ITEMS 1 20 1
INDEX UNIQUE SCAN PK_SVC_QUOTE_LINE_ITEMS 1
The "bad" Insert plan:
Operation Object Name Rows Bytes Cost Object Node In/Out PStart PStop
INSERT STATEMENT Hint=HINT: ALL_ROWS 1 226
SEQUENCE SVC_C_SS_QUOTE_LINE_ITEM_ID
NESTED LOOPS 1 260 226
NESTED LOOPS 1 240 225
FILTER
HASH JOIN OUTER
HASH JOIN 1 182 155
VIEW 1 55 103
SORT GROUP BY 1 143 103
HASH JOIN 1 143 101
HASH JOIN 2 258 98
TABLE ACCESS BY INDEX ROWID PARTREGIONLISTPRICE 2
96 1
NESTED LOOPS 2 252 95
NESTED LOOPS 1 78 94
NESTED LOOPS 1 75 93
FILTER
HASH JOIN OUTER
NESTED LOOPS 1 50 23
TABLE ACCESS BY INDEX
ROWID SVC_QUOTES 1 6 1
INDEX UNIQUE SCAN PK_SVC_QUOTES 1
1
VIEW 1 44 22
NESTED LOOPS 1 102 22
NESTED LOOPS 1 95 21
NESTED LOOPS 1 88 20
NESTED LOOPS 1 84 19
NESTED LOOPS 1 71 18
NESTED LOOPS 2 128
17
NESTED LOOPS OUTER 2
112 16
HASH JOIN 2 100
15
HASH JOIN 60 1
K 5
VIEW SVC_QUOTE_PROD_LINE_CODES_ALL 60 1 K 2
UNION-ALL
NESTED
LOOPS 1 K 23 K 6
HASH
JOIN 1 K 19 K 5
TABLE
ACCESS FULL SVC_QUOTE_PROD_LINE_CODES_SOM 1 K 10 K 2
TABLE
ACCESS FULL SVC_PELM 4 K 24 K 2
INDEX
UNIQUE SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
NESTED
LOOPS 1 K 23 K 6
HASH
JOIN 1 K 19 K 5
TABLE
ACCESS FULL SVC_QUOTE_PROD_LINE_CODES_HOM 1 K 10 K 2
TABLE
ACCESS FULL SVC_PELM 4 K 24 K 2
INDEX
UNIQUE SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
TABLE ACCESS
FULL SVC_PELM 4 K 32 K 2
VIEW 54 1 K 9
HASH JOIN 54
2 K 9
MERGE JOIN
CARTESIAN 34 986 6
MERGE JOIN
CARTESIAN 3 75 5
MERGE
JOIN CARTESIAN 2 46 4
NESTED
LOOPS 1 16 2
TABLE
ACCESS BY INDEX ROWID SVC_QUOTES 1 6 1
INDEX UNIQUE SCAN PK_SVC_QUOTES 1 1
TABLE
ACCESS BY INDEX ROWID DISTRIBUTOR 1 10 1
INDEX RANGE SCAN DISTRIBUTOR_IDX_017 1 1
BUFFER
SORT 2 14 3
TABLE
ACCESS FULL SVC_QUOTE_EQUIP_LOC 2 14 2
BUFFER
SORT 2 4 3
INDEX
FULL SCAN PK_SVC_SERVICE_TYPES 2 4 1
BUFFER
SORT 11 44 5
INDEX
FULL SCAN PK_SVC_CEANTAR_GPPC_REGION_MAP 11 44 1
TABLE ACCESS
FULL CUSTOMERMASTER 1 K 20 K 2
VIEW PUSHED
PREDICATE SVC_GEO_MAX_AVAILABILITY 1 6 1
HASH JOIN 3
168 11
HASH JOIN 40
1 K 6
MERGE JOIN
CARTESIAN 35 350 3
TABLE
ACCESS BY INDEX ROWID SVC_SERVICE_TYPES 1 4 1
INDEX
UNIQUE SCAN PK_SVC_SERVICE_TYPES 1
TABLE
ACCESS FULL SVC_ROOTS 35 210 2
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 2 K 2
VIEW VW_NSO_1 32 960 4
SORT GROUP
BY 32 320 4
TABLE
ACCESS FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 1 K 2
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_LINE_ITEMS 1 8 1
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
TABLE ACCESS BY INDEX
ROWID SVC_ROOT_REGION_MAP 1 7 1
INDEX RANGE
SCAN IX_SVC_ROOT_REGION_MAP_ROOT 2
TABLE ACCESS BY INDEX
ROWID SVC_ROOTS 1 13 1
INDEX UNIQUE
SCAN PK_SVC_ROOTS 1
INDEX UNIQUE
SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 1 4
TABLE ACCESS BY INDEX
ROWID SVC_ROOT_REGION_MAP 1 7 1
INDEX RANGE
SCAN IX_SVC_ROOT_REGION_MAP_SEQ 5 1
TABLE ACCESS BY INDEX
ROWID SVC_ROOTS 1 7 1
INDEX UNIQUE
SCAN PK_SVC_ROOTS 1
VIEW SVC_CB_PECS_FOR_PLG 1 12 68
SORT UNIQUE 1 54 68
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_LINE_ITEMS 2 8 1
NESTED LOOPS 1 54 66
NESTED LOOPS 1 50 65
NESTED LOOPS 1 46 64
NESTED LOOPS 1 38 63
NESTED LOOPS 1 27
62
NESTED LOOPS 1 24
61
VIEW 1 18 60
SORT GROUP BY 1
19 60
NESTED LOOPS 1
19 58
NESTED
LOOPS 1 13 57
MERGE JOIN
CARTESIAN 1 9 56
TABLE
ACCESS FULL SVC_QUOTE_LINE_ITEMS 1 7 55
BUFFER
SORT 2 4 1
INDEX
FULL SCAN PK_SVC_COUNT_BASED_PLGS 2 4 1
INDEX
UNIQUE SCAN PK_SVC_CB_PLG_TYPES_MAP 1 4
TABLE ACCESS
BY INDEX ROWID SVC_PELM 1 6 1
INDEX
UNIQUE SCAN PK_SVC_PELM 1
TABLE ACCESS BY
INDEX ROWID SVC_QUOTE_EQUIP_LOC 1 6 1
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1
INDEX UNIQUE
SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX
ROWID SVC_COUNT_BASED_PLGS 1 11 1
INDEX UNIQUE
SCAN PK_SVC_COUNT_BASED_PLGS 1
TABLE ACCESS BY INDEX
ROWID SVC_PELM 1 8 1
INDEX RANGE
SCAN IX_SVC_PELM_QEL_ID 2
INDEX RANGE
SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 2 8 1
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
TABLE ACCESS BY INDEX ROWID DISTRIBUTOR 1
13 1
INDEX RANGE SCAN DISTRIBUTOR_IDX_017 1
1
INDEX UNIQUE SCAN PK_COUNTRY 1 3
INDEX RANGE SCAN PRLP_OCODE 6
TABLE ACCESS FULL MODELCURRENCY 70 210 2
TABLE ACCESS FULL CUSTOMERMASTER 1 K 23 K 2
VIEW 17 2 K 51
NESTED LOOPS OUTER 17 1 K 51
HASH JOIN 17 1 K 46
TABLE ACCESS BY INDEX ROWID SVC_QUOTE_LINE_ITEMS 1
12 1
NESTED LOOPS 6 474 29
HASH JOIN 31 2 K 19
TABLE ACCESS FULL SVC_ROOT_REGION_MAP 104
728 2
HASH JOIN 1 K 72 K 16
HASH JOIN 1 K 62 K 13
TABLE ACCESS FULL SVC_ROOT_REGION_MAP 104
728 2
HASH JOIN 18 K 808 K 10
VIEW SVC_QUOTE_PROD_LINE_CODES_ALL 60
1 K 2
UNION-ALL
NESTED LOOPS 1 K 23 K 6
HASH JOIN 1 K 19 K 5
TABLE ACCESS
FULL SVC_QUOTE_PROD_LINE_CODES_SOM 1 K 10 K 2
TABLE ACCESS FULL SVC_PELM 4
K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
NESTED LOOPS 1 K 23 K 6
HASH JOIN 1 K 19 K 5
TABLE ACCESS
FULL SVC_QUOTE_PROD_LINE_CODES_HOM 1 K 10 K 2
TABLE ACCESS FULL SVC_PELM 4
K 24 K 2
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1 3
HASH JOIN 613 14 K 7
HASH JOIN 70 1 K 4
INDEX FULL
SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 4 16 1
TABLE ACCESS FULL SVC_ROOTS 35
455 2
TABLE ACCESS FULL SVC_ROOTS 35 245
2
TABLE ACCESS FULL SVC_PELM 4 K 32 K 2
INDEX RANGE
SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
VIEW 100 K 2 M 16
HASH JOIN 100 K 3 M 16
TABLE ACCESS FULL SVC_QUOTE_EQUIP_LOC 2 K 19
K 2
HASH JOIN 65 K 2 M 12
TABLE ACCESS FULL SVC_QUOTES 1 K 11 K 2
HASH JOIN 102 K 2 M 8
INDEX FAST FULL SCAN DISTRIBUTOR_IDX_011 2
K 28 K 2
HASH JOIN 3 K 61 K 5
MERGE JOIN CARTESIAN 22 132 2
INDEX FULL SCAN PK_SVC_SERVICE_TYPES 2
4 1
BUFFER SORT 11 44 1
INDEX FULL
SCAN PK_SVC_CEANTAR_GPPC_REGION_MAP 11 44 1
TABLE ACCESS FULL CUSTOMERMASTER 1 K 20
K 2
VIEW PUSHED PREDICATE SVC_GEO_MAX_AVAILABILITY 1 6
1
HASH JOIN SEMI 4 224 11
HASH JOIN 40 1 K 6
MERGE JOIN CARTESIAN 35 350 3
TABLE ACCESS BY INDEX
ROWID SVC_SERVICE_TYPES 1 4 1
INDEX UNIQUE SCAN PK_SVC_SERVICE_TYPES 1
TABLE ACCESS FULL SVC_ROOTS 35 210 2
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 2 K 2
VIEW VW_NSO_2 32 960 4
SORT GROUP BY 32 320 4
TABLE ACCESS
FULL SVC_CLARIFY_GEO_AVAIL_CACHE 161 1 K 2
VIEW SVC_CB_PECS_FOR_PLG 1 55 68
SORT UNIQUE 1 54 68
TABLE ACCESS BY INDEX ROWID SVC_QUOTE_LINE_ITEMS 2 8
1
NESTED LOOPS 1 54 66
NESTED LOOPS 1 50 65
NESTED LOOPS 1 46 64
NESTED LOOPS 1 38 63
NESTED LOOPS 1 27 62
NESTED LOOPS 1 24 61
VIEW 1 18 60
SORT GROUP BY 1 19 60
NESTED LOOPS 1 19 58
NESTED LOOPS 1 13 57
MERGE JOIN CARTESIAN 1 9 56
TABLE ACCESS
FULL SVC_QUOTE_LINE_ITEMS 1 7 55
BUFFER SORT 2 4 1
INDEX FULL
SCAN PK_SVC_COUNT_BASED_PLGS 2 4 1
INDEX UNIQUE
SCAN PK_SVC_CB_PLG_TYPES_MAP 1 4
TABLE ACCESS BY INDEX
ROWID SVC_PELM 1 6 1
INDEX UNIQUE SCAN PK_SVC_PELM 1
TABLE ACCESS BY INDEX
ROWID SVC_QUOTE_EQUIP_LOC 1 6 1
INDEX UNIQUE
SCAN PK_SVC_QUOTE_EQUIP_LOC 1
INDEX UNIQUE SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX
ROWID SVC_COUNT_BASED_PLGS 1 11 1
INDEX UNIQUE SCAN PK_SVC_COUNT_BASED_PLGS 1
TABLE ACCESS BY INDEX ROWID SVC_PELM 1 8 1
INDEX RANGE SCAN IX_SVC_PELM_QEL_ID 2
INDEX RANGE SCAN PK_SVC_RT_TYPE_ITM_CAT_MAP 2 8
1
INDEX RANGE SCAN IX_SVC_QUOTE_LINE_ITEMS_PELM 11
INDEX UNIQUE SCAN PK_SVC_QUOTES 1 3
TABLE ACCESS BY INDEX ROWID SVC_QUOTE_LINE_ITEMS 1 20 1
INDEX UNIQUE SCAN PK_SVC_QUOTE_LINE_ITEMS 1
Received on Thu Aug 31 2006 - 09:15:48 CDT
 |
 |