About Rebuilding Local Index Partitions

Rebuild local indexes using either ALTER INDEX or ALTER TABLE as follows:

• ALTER INDEX REBUILD PARTITION/SUBPARTITION

  This statement rebuilds an index partition or subpartition unconditionally.

• ALTER TABLE MODIFY PARTITION/SUBPARTITION REBUILD UNUSABLE LOCAL INDEXES

  This statement finds all of the unusable indexes for the given table partition or subpartition and rebuilds them. It only rebuilds an index partition if it has been marked UNUSABLE.

The following sections contain examples about rebuilding indexes.

• Using ALTER INDEX to Rebuild a Partition

• Using ALTER TABLE to Rebuild an Index Partition