Procedure documentation Activating and Deactivating Indexes Locate the document in its SAP Library structure

Use

You can determine which of the existing indexes of a Structure linkdatabase instance are used.

You can also activate or deactivate selected indexes and thereby change the access times.

Prerequisites

The database instance is in the ONLINE Structure linkoperational state.

Procedure

  1. Choose Instance ® Tuning ® Index Use.
  2. You can choose which indexes are to be displayed. To do so, enter appropriate search arguments under Owner and Table Name or Index Name.

    3. Owner

    Owner

    Table Name

    Name of the table

    Index Name

    Name of the index

    You can also choose between the following options:

    Disabled indexes only

    Only indexes that have been deactivated

    Unused indexes only

    Only indexes that have not been used

  3. Then choose Indexes ® Search. The system displays a list of the indexes that match your criteria.
  4. Select the indexes you want to activate in the list. If you want to activate all of the indexes displayed, choose Indexes ® Mark All.
    Deselect the indexes you want to deactivate in the list.
  5. Choose Indexes and the desired action.