About Rebuilding Index Partitions

Some reasons for rebuilding index partitions include:

  • To recover space and improve performance

  • To repair a damaged index partition caused by media failure

  • To rebuild a local index partition after loading the underlying table partition with SQL*Loader or an import utility

  • To rebuild index partitions that have been marked UNUSABLE

  • To enable key compression for B-tree indexes

The following sections discuss options for rebuilding index partitions and subpartitions.

This section contains the following topics: