Explain Plan:
Operation Object Name Rows Bytes Cost
SELECT STATEMENT Hint=ALL_ROWS 2 59.6511278513511
SORT ORDER BY 2 124 K 59.6511278513511
VIEW MSC_ITEM_ATTRIBUTES_V 2 124 K 58.6511150357006
UNION-ALL
NESTED LOOPS 1 205 52.6442829525777
PARTITION RANGE SINGLE 53 2 K 14.0140833960738
TABLE ACCESS BY LOCAL INDEX ROWID MSC_ITEM_CATEGORIES 53
2 K 14.0140833960738
INDEX RANGE SCAN
MSC_ITEM_CATEGORIES_N1 53 2.00356168996366
PARTITION RANGE SINGLE 1 158 1.0022985390916
TABLE ACCESS BY LOCAL INDEX ROWID MSC_SYSTEM_ITEMS 1 158
1.0022985390916
INDEX UNIQUE SCAN MSC_SYSTEM_ITEMS_U1 1
.00116217207592274
FILTER
TABLE ACCESS BY LOCAL INDEX ROWID MSC_ITEM_CATEGORIES 1 47
2.00185480128323
NESTED LOOPS 1 1 K 6.00683208312297
NESTED LOOPS 1 1019 4.00497728183974
TABLE ACCESS BY INDEX ROWID MSC_ITEM_ATTRIBUTES 1 859
2.00230591196596
INDEX RANGE SCAN MSC_ITEM_ATTRIBUTES_N2 258
1.00104128196787
PARTITION RANGE ITERATOR 1 160
2.00267136987378
TABLE ACCESS BY LOCAL INDEX ROWID MSC_SYSTEM_ITEMS 1
160 2.00267136987378
INDEX RANGE SCAN MSC_SYSTEM_ITEMS_U3 1
1.00116217207592
PARTITION RANGE SINGLE 1 1.00116217207592
INDEX RANGE SCAN MSC_ITEM_CATEGORIES_U1
1 1.00116217207592
Received on Fri Sep 02 2005 - 00:30:02 CDT
