Code Listing 4: Results from hash-partitioned tables 
                             
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------------------
Plan hash value: 2303213640
  --------------------------------------------------------------------------------------------------------------
|   Id  |   Operation             |    Name   |   Rows |    Bytes  | Cost (%CPU) | Time     |  Pstart |  Pstop |
----------------------------------------------------------------------------------------------------------------
|    0  |   SELECT STATEMENT      |           |   1    |     78    |   11 (19)   | 00:00:01 |         |        |
|    1  |   HASH GROUP BY         |           |   1    |     78    |   11 (19)   | 00:00:01 |         |        |
|  * 2  |   HASH JOIN             |           |   1    |     78    |   10 (10)   | 00:00:01 |         |        |
|    3  |   PARTITION HASH SINGLE |           |   1    |     39    |    4  (0)   | 00:00:01 |   4     | 4      |
|  * 4  |   TABLE ACCESS FULL     |TRANS      |   1    |     39    |    4  (0)   | 00:00:01 |   4     | 4      |
|    5  |   PARTITION HASH SINGLE |           |   1    |     39    |    5  (0)   | 00:00:01 |   4     | 4      |
|  * 6  |   TABLE ACCESS FULL     |ADVERTISING|   1    |     39    |    5  (0)   | 00:00:01 |   4     | 4      |
----------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
----------------------------------------------------------------------------------------------------------------
   2 - access("T"."TRANS_ID"="A"."AD_ID" AND "T"."PRODUCT_CODE"="A"."PRODUCT_CODE")
   4 - filter("T"."TRANS_ID"=101)
   6 - filter("A"."AD_ID"=101)