
6.3 Tuning Queries with Partitioning 153
Chapter 6
6.3 Tuning Queries with Partitioning
This section examines how queries behave when using Oracle Partitioning.
The four areas to be discussed are: understanding EXPLAIN PLAN com-
mand results, parallel processing as applied to partitioning, partition prun-
ing, and partition-wise joins.
6.3.1 Partitioning EXPLAIN PLANs
The EXPLAIN PLAN command produces an assessment of the way in
which a query could be executed by the optimizer,[1] generating results
into a table called PLAN_TABLE, more commonly known as the query
plan table. The four columns OTHER_TAG, PARTITION_START,
PARTITION_STOP, and PARTITION_ID will ...