Procedure documentationActivating or Deactivating the Automatic Recreation of Damaged Indexes Locate this document in the navigation structure


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


  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose   Administration Tasks   Automatic Recreation of Bad Indexes  .

  3. Select ALL.