Procedure documentationActivating or Deactivating Indexes Locate this document in the navigation structure

 

If you deactivate an index, the database system no longer uses it to access data in the database.

Prerequisites

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

  • You have the INDEX privilege for the table for which the index has been defined.

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

  • The database is in the ONLINE operational state.

Procedure

  1. Open the index overview.

    More information: Displaying Indexes

  2. To activate an index, choose Enable in the context menu of the index.

    To deactivate an index, choose Disable in the context menu of the index.