SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY()); PLAN_TABLE_OUTPUT ----------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost | ------------------------------------------------------------------------------------------------------ | 0 | SELECT STATEMENT | | 1 | 121 | | 69907| | 1 | MERGE JOIN | | 1 | 121 | | 69907| | 2 | SORT JOIN | | 96P| 9611P| 20677| 69907| | 3 | MERGE JOIN | | 96P| 9611P| | 69907| | 4 | SORT JOIN | | 54294| 44847| 10129| 69907| | 5 | MERGE JOIN | | 54294| 44847| | 69907| | 6 | SORT JOIN | | 57986| 43777| 12054| 69907| | 7 | MERGE JOIN CARTESIAN | | 57986| 43777| | 69907| | 8 | MERGE JOIN CARTESIAN | | 2787P| 74270| | 1973T| | 9 | MERGE JOIN CARTESIAN | | 6324G| 115T| | 2850M| | 10 | MERGE JOIN CARTESIAN | | 401M| 5742M| | 40M| | 11 | SORT UNIQUE | | | | | | | 12 | INDEX FAST FULL SCAN| IX_STR_STORE_FLOORPLAN_I1 | 263K| 2055K| | 141 | | 13 | BUFFER SORT | | 1526 | 10682 | | 40M| | 14 | SORT UNIQUE | | | | | | |* 15 | TABLE ACCESS FULL | IX_FLR_FLOORPLAN | 1526 | 10682 | | 154 | | 16 | BUFFER SORT | | 15755 | 78775 | | 2850M| | 17 | SORT UNIQUE | | | | | | | 18 | INDEX FAST FULL SCAN| IX_SPC_PLANOGRAM_P1 | 15755 | 78775 | | 7 | | 19 | BUFFER SORT | | 440K| 4304K| | 1973T| | 20 | SORT UNIQUE | | | | | | | 21 | INDEX FAST FULL SCAN | IX_SPC_POSITION_I1 | 440K| 4304K| | 312 | | 22 | BUFFER SORT | | 20M| 1091M| | 69907| | 23 | TABLE ACCESS FULL | STORELINESALES | 20M| 1091M| | 25080 | |* 24 | SORT JOIN | | 1067 | 8536 | | 14 | | 25 | VIEW | index$_join$_002 | 1067 | 8536 | | 10 | |* 26 | HASH JOIN | | 54294| 44847| | 69907| | 27 | INDEX FAST FULL SCAN | IX_STR_STORE_P1 | 1067 | 8536 | | 4 | | 28 | INDEX FAST FULL SCAN | IX_STR_STORE_I5 | 1067 | 8536 | | 4 | |* 29 | SORT JOIN | | 489K| 9083K| 26M| 7955 | | 30 | VIEW | index$_join$_003 | 489K| 9083K| | 4794 | |* 31 | HASH JOIN | | 96P| 9611P| 26M| 69907| | 32 | INDEX FAST FULL SCAN | IX_SPC_PRODUCT_P1 | 489K| 9083K| | 1160 | | 33 | INDEX FAST FULL SCAN | IX_SPC_PRODUCT_I1 | 489K| 9083K| | 1160 | |* 34 | SORT JOIN | | 102K| 898K| 4024K| 395 | | 35 | INDEX FAST FULL SCAN | IX_FLR_SECTION_I1 | 102K| 898K| | 118 | ------------------------------------------------------------------------------------------------------ Predicate Information (identified by operation id): --------------------------------------------------- 15 - filter("FLR"."DBSTATUS"=1) 24 - access("WK"."STORE"="ST"."STORENUMBER") filter("STFL"."DBPARENTSTOREKEY"="ST"."DBKEY" AND "WK"."STORE"="ST"."STORENUMBER") 26 - access("indexjoin$_alias$_010".ROWID="indexjoin$_alias$_009".ROWID) 29 - access("WK"."LINE"="PRD"."ID") filter("SPPOS"."DBPARENTPRODUCTKEY"="PRD"."DBKEY" AND "WK"."LINE"="PRD"."ID") 31 - access("indexjoin$_alias$_012".ROWID="indexjoin$_alias$_011".ROWID) 34 - access("PRD"."DBKEY"="SEC"."DBPARENTPLANOGRAMKEY") filter("STFL"."DBPARENTFLOORPLANKEY"="SEC"."DBPARENTFLOORPLANKEY" AND "FLR"."DBKEY"="SEC"."DBPARENTFLOORPLANKEY" AND "SPCPLN"."DBKEY"="SEC"."DBPARENTPLANOGRAMKEY" AND "SPPOS"."DBPARENTPLANOGRAMKEY"="SEC"."DBPARENTPLANOGRAMKEY" AND "ST"."DBKEY"="SEC"."DBPARENTFLOORPLANKEY" AND "PRD"."DBKEY"="SEC"."DBPARENTPLANOGRAMKEY") Note: cpu costing is off