PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------
| Id  | Operation             | Name     | Rows  | Bytes |TempSpc| Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |          |       |       |       | 59903 (100)|          |
|   1 |  SORT ORDER BY        |          |   582K|    33M|    40M| 59903   (1)| 00:11:59 |
|   2 |   HASH GROUP BY       |          |   582K|    33M|    40M| 59903   (1)| 00:11:59 |
|*  3 |    HASH JOIN          |          |   582K|    33M|    11M| 43155   (1)| 00:08:38 |
|*  4 |     HASH JOIN         |          |   256K|  9265K|       |  7553   (1)| 00:01:31 |
|*  5 |      TABLE ACCESS FULL| CUSTOMER | 30000 |   468K|       |   951   (1)| 00:00:12 |
|*  6 |      TABLE ACCESS FULL| ORDERS   |   741K|    14M|       |  6599   (1)| 00:01:20 |
|*  7 |     TABLE ACCESS FULL | LINEITEM |  3206K|    70M|       | 29681   (1)| 00:05:57 |

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

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

   3 - access("L_ORDERKEY"="O_ORDERKEY")
   4 - access("C_CUSTKEY"="O_CUSTKEY")
   5 - filter("C_MKTSEGMENT"='BUILDING')
   6 - filter("O_ORDERDATE"<TO_DATE(' 1995-03-23 00:00:00', 'syyyy-mm-dd
              hh24:mi:ss'))
   7 - filter("L_SHIPDATE">TO_DATE(' 1995-03-23 00:00:00', 'syyyy-mm-dd

PLAN_TABLE_OUTPUT