Index Implications for Interval Partitioning
Interval partitioning, which is available as of Oracle 11g, is a wonderful feature that has Oracle automatically create partitions on a table when incoming data doesn't match the partition boundaries on a table. In early versions of Oracle, trying to insert new data would have generated an Oracle error and the DML operation fail. With interval partitioning, Oracle now simply adds new partitions as needed to match the incoming data.
In regards to indexes on interval-based table partitioning, similar rules apply as if you were using other partitioning methods, such as locally partitioned indexes. On your interval-based partitioned local indexes, if you want your new index partitions to be placed in a ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
