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:

• About Rebuilding Global Index Partitions

• About Rebuilding Local Index Partitions