Database VLDB and Partitioning Guide
ContentsOpens a new window
Opens a new window
Page 225 of 478

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:

Previous PageOpens a new window
Page 225 of 478
Next PageOpens a new window