Rebuilding index partitions

The REBUILD INDEX utility can rebuild one or more partitions of a partitioned index by extracting the keys from the data rows of the table on which they are based.

When you specify the PART option, one or more partitions from a partitioning index or a data-partitioned secondary index can be rebuilt. However, for nonpartitioned indexes, you cannot rebuild individual logical partitions in certain situations.

If any of the following situations are true for a nonpartitioned index, you cannot rebuild individual logical partitions:

  • the index was created with DEFER YES
  • the index must be completely rebuilt (This situation is likely in a disaster recovery scenario)
  • the index is in page set REBUILD-pending (PSRBD) status

For these cases, you must rebuild the entire index.