-------------------------------------------------------------------------------------------------
| Id  | Operation                         |  Name                       | Rows  | Bytes | Cost  |
-------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                  |                             |     1 |    70 |   874 |
|   3 |  TEMP TABLE TRANSFORMATION        |                             |       |       |       |
|   1 |   RECURSIVE EXECUTION             | SYS_LE_3_0                  |       |       |       |
|   0 |    INSERT STATEMENT               |                             |  1643 | 31217 |   861 |
|   1 |     LOAD AS SELECT                |                             |       |       |       |
|   2 |      TABLE ACCESS FULL            | ORDER_ITEM          		|  1643 | 31217 |   861 |
|   2 |   RECURSIVE EXECUTION             | SYS_LE_3_1                  |       |       |       |

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
|   0 |    INSERT STATEMENT               |                             |  1990K|    45M|   151K|
|   1 |     LOAD AS SELECT                |                             |       |       |       |
|   2 |      TABLE ACCESS FULL            | ITEM				        |  1990K|    45M|   151K|
|   4 |   SORT GROUP BY                   |                             |     1 |    70 |       |
|   5 |    TABLE ACCESS BY INDEX ROWID    | TRANSFER_DATA_TBL	        |     1 |    18 |     4 |
|   6 |     NESTED LOOPS                  |                             |     1 |    70 |   874 |
|   7 |      NESTED LOOPS                 |                             |     1 |    52 |   870 |
|   8 |       NESTED LOOPS                |                             |     1 |    43 |   868 |
|   9 |        TABLE ACCESS FULL          | COMMUNICATION_ITEM          |     1 |    19 |   861 |
|  10 |        TABLE ACCESS BY INDEX ROWID| ITEM				        |     1 |    24 |     7 |
|  11 |         INDEX RANGE SCAN          | PK_ITEM				        |     4 |       |     3 |