Procedure documentationRecreating Damaged Indexes Locate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You have the INDEX privilege for the table to which the damaged index belongs.

    More information: SQL Reference Manual, Privilege Specification (privilege_specification)

  • The database is in the ONLINE operational state.

Procedure

Automatically Recreating Indexes

See Activating or Deactivating the Automatic Recreation of Damaged Indexes

Manually Recreating Indexes

Recommendation Recommendation

Recreate indexes during periods where the load on the system is low.

End of the recommendation.

  1. Display the damaged indexes.

    More information: Displaying Indexes

  2. In the context menu of each damaged index, choose Recreate.

    The system deletes the damaged index and recreates it.

More Information