SQL> set trimspool on
SQL> SELECT PLAN_TABLE_OUTPUT FROM TABLE(DBMS_XPLAN.DISPLAY());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------------
| Id  | Operation                   |  Name                      | Rows  | Bytes |TempSpc| Cost  |
--------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                            |  2742K|   316M|       |   272K|
|*  1 |  HASH JOIN                  |                            |  2742K|   316M|  5144K|   272K|
|   2 |   INDEX FAST FULL SCAN      | IX_STR_STORE_FLOORPLAN_I1  |   263K|  2055K|       |   141 |
|*  3 |   HASH JOIN                 |                            |    33M|  3603M|       |   102K|
|   4 |    VIEW                     | index$_join$_002           |  1067 |  8536 |       |    10 |
|*  5 |     HASH JOIN               |                            |    33M|  3603M|       |   102K|
|   6 |      INDEX FAST FULL SCAN   | IX_STR_STORE_P1            |  1067 |  8536 |       |     4 |
|   7 |      INDEX FAST FULL SCAN   | IX_STR_STORE_I5            |  1067 |  8536 |       |     4 |
|*  8 |    HASH JOIN                |                            |    33M|  3351M|    53M| 98064 |
|*  9 |     HASH JOIN               |                            |   903K|    43M|    14M|  6972 |
|  10 |      VIEW                   | index$_join$_008           |   489K|  9083K|       |  4794 |
|* 11 |       HASH JOIN             |                            |   903K|    43M|    14M|  6972 |
|  12 |        INDEX FAST FULL SCAN | IX_SPC_PRODUCT_P1          |   489K|  9083K|       |  1160 |
|  13 |        INDEX FAST FULL SCAN | IX_SPC_PRODUCT_I1          |   489K|  9083K|       |  1160 |
|* 14 |      HASH JOIN              |                            |   903K|    26M|  1048K|   853 |
|  15 |       NESTED LOOPS          |                            | 32311 |   662K|       |   276 |
|* 16 |        HASH JOIN            |                            | 32311 |   504K|       |   276 |
|* 17 |         TABLE ACCESS FULL   | IX_FLR_FLOORPLAN           |  1526 | 10682 |       |   154 |
|  18 |         INDEX FAST FULL SCAN| IX_FLR_SECTION_I1          |   102K|   898K|       |   118 |
|* 19 |        INDEX UNIQUE SCAN    | IX_SPC_PLANOGRAM_P1        |     1 |     5 |       |       |
|  20 |       INDEX FAST FULL SCAN  | IX_SPC_POSITION_I1         |   440K|  4304K|       |   312 |
|  21 |     TABLE ACCESS FULL       | STORELINESALES             |    20M|  1091M|       | 25080 |
--------------------------------------------------------------------------------------------------

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - access("STFL"."DBPARENTFLOORPLANKEY"="FLR"."DBKEY" AND
              "ST"."DBKEY"="STFL"."DBPARENTSTOREKEY")
   3 - access("WK"."STORE"="ST"."STORENUMBER")
   5 - access("indexjoin$_alias$_012".ROWID="indexjoin$_alias$_011".ROWID)
   8 - access("WK"."LINE"="PRD"."ID")
   9 - access("PRD"."DBKEY"="SPPOS"."DBPARENTPRODUCTKEY")
  11 - access("indexjoin$_alias$_010".ROWID="indexjoin$_alias$_009".ROWID)
  14 - access("SPPOS"."DBPARENTPLANOGRAMKEY"="SPCPLN"."DBKEY")
  16 - access("FLR"."DBKEY"="SEC"."DBPARENTFLOORPLANKEY")
  17 - filter("FLR"."DBSTATUS"=1)
  19 - access("SEC"."DBPARENTPLANOGRAMKEY"="SPCPLN"."DBKEY")

Note: cpu costing is off

44 rows selected.

Elapsed: 00:00:00.03
SQL> spoo off
