Procedure documentationRestoring 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

Activating Automatic Restoration of Damaged Indexes

If you want the system to restore all damaged indexes automatically after it has restored the database, set the UseAutomaticBadIndexRecreation special database parameter to YES.

More information: Changing Database Parameters

Restoring Indexes Manually

Recommendation Recommendation

Restore 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.