Entering content frameProcedure documentation Activating and Deactivating Indices Locate the document in its SAP Library structure

Use

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

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

Prerequisites

The database instance is in ONLINE mode.

Procedure

  1. Choose Instance ® Tuning ® Index Use.
  2. You can choose which indices 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 indices that have been deactivated

    Unused indexes only

    Only indices that have not been used

  3. Then choose Indexes ® Select. A list of the indices that match your criteria is then displayed.
  4. Select the indices you want to activate in the list. If you want to activate all of the indices displayed, choose Indexes ® Mark All.
    Select the indices you want to deactivate in the list.
  5. Choose Indexes and the required action.

 

 

Leaving content frame