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: