Understanding Partitioned Indexes

Partitioned indexes offer many advantages over their non-partitioned counterparts. The key advantages of using partitioned indexes include:

  • Performance benefits
    • Loading data via DML operations.
    • Loading data via DDL operations.
    • Querying data via SELECT statements.
  • Maintenance benefits
    • Rebuilding indexes.
    • Setting indexes unusable or invisible at a partition-level.

You can create partitioned indexes either as locally partitioned or globally partitioned. Locally partitioned indexes can only exist on partitioned tables, while globally partitioned indexes can be created on partitioned or non-partitioned tables. You can also create non-partitioned indexes on partitioned tables. The most common configuration ...

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.