Table of Contents Previous Next


10 Table Partitioning : 10.2 Using Partition Pruning : 10.2.1 Example - Partition Pruning

The EXPLAIN statement displays the execution plan of a statement. You can use the EXPLAIN statement to confirm that Advanced Server is pruning partitions from the execution plan of a query.
The resulting query plan shows that the server will scan only the sales_asia table - the table in which a row with a country value of INDIA would be stored:
(
PARTITION
"2011" VALUES LESS THAN('01-JAN-2012')
SUBPARTITION europe_2011 VALUES ('ITALY', 'FRANCE'),
SUBPARTITION asia_2011 VALUES ('PAKISTAN', 'INDIA'),
SUBPARTITION americas_2011 VALUES ('US', 'CANADA')
PARTITION "2012" VALUES LESS THAN('01-JAN-2013')
SUBPARTITION europe_2012 VALUES ('ITALY', 'FRANCE'),
SUBPARTITION asia_2012 VALUES ('PAKISTAN', 'INDIA'),
SUBPARTITION americas_2012 VALUES ('US', 'CANADA')
),
PARTITION
"2013" VALUES LESS THAN('01-JAN-2015')
SUBPARTITION europe_2013 VALUES ('ITALY', 'FRANCE'),
SUBPARTITION asia_2013 VALUES ('PAKISTAN', 'INDIA'),
SUBPARTITION americas_2013 VALUES ('US', 'CANADA')

10 Table Partitioning : 10.2 Using Partition Pruning : 10.2.1 Example - Partition Pruning

Table of Contents Previous Next