Database Reference
In-Depth Information
-------------------------------------------------------------------------------
| Id | Operation | Name | Starts | Pstart| Pstop | Buffers |
-------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | | 630 |
|* 1 | HASH JOIN | | 1 | | | 630 |
| 2 | PART JOIN FILTER CREATE| :BF0000 | 1 | | | 403 |
|* 3 | TABLE ACCESS FULL | TX | 1 | | | 403 |
| 4 |
PARTITION RANGE AND
| | 1 |
KEY(AP)
|
KEY(AP)
| 227 |
|* 5 | TABLE ACCESS FULL | T | 6 |
KEY(AP)
|
KEY(AP)
| 227 |
-------------------------------------------------------------------------------
1 - access("TX"."N1"="T"."N1" AND "TX"."D1"="T"."D1")
3 - filter(("TX"."N2"=42 AND "TX"."N1"=3))
5 - filter("T"."N1"=3)
Hash and List Partitioning
The previous section covered range partitioning only. Anyway, with hash and list partitioning, most of the techniques
described for range partitioning are available as well.
The following are the operations available with hash partitioning. The
pruning_hash.sql
script provides
examples of execution plans that contain these operations:
•
PARTITION HASH SINGLE
PARTITION HASH ITERATOR
•
PARTITION HASH INLIST
•
PARTITION HASH ALL
•
PARTITION HASH SUBQUERY
•
PARTITION HASH JOIN-FILTER
•
PARTITION HASH AND
The following are the operations available with list partitioning. The
pruning_list.sql
script provides examples
of execution plans containing these operations:
•
PARTITION LIST SINGLE
•
PARTITION LIST ITERATOR
•
PARTITION LIST INLIST
•
PARTITION LIST ALL
•
PARTITION LIST EMPTY
•
PARTITION LIST OR
•
PARTITION LIST SUBQUERY
•
PARTITION LIST JOIN-FILTER
•
PARTITION LIST AND
•