Partial Indexes for Partitioned Tables

Turn indexing for (sub)partitions on or off 
The default value is specified at the table level
The default value can be overridden at the (sub)partition level
The query optimizer takes advantage of the table expansion query transformation to make sure that data is accessed in the optimal way
Partial indexes are supported for both local and global indexes


CREATE TABLE t (…)
INDEXING OFF
PARTITION BY RANGE (d) (
 PARTITION t_jan_2013 VALUES LESS THAN (…),
 PARTITION t_feb_2013 VALUES LESS THAN (…),
 PARTITION t_mar_2013 VALUES LESS THAN (…),
 …
 PARTITION t_oct_2013 VALUES LESS THAN (…),
 PARTITION t_nov_2013 VALUES LESS THAN (…),
 PARTITION t_dec_2013 VALUES LESS THAN (…) INDEXING ON
);