Entering content frame

Procedure documentation Activating, Deactivating, or Deleting Indexes Locate the document in its SAP Library structure

You can use the Database Manager GUI to determine which of the existing indexes have been used in a database instance.

You can also activate, deactivate, or delete selected indexes.

Prerequisites

The database instance is in the operational state ONLINE.

Procedure

1.       Choose Instance ® Tuning ® Index Use.

2.       You can choose which indexes you want to display. To do this, enter appropriate search arguments:

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.       Choose Actions ® Search. The system displays a list of the indexes that match your criteria.

4.       Select the indexes that you want to activate.
If you want to activate all of the indexes displayed, choose Actions
® Mark All.
Deselect the indexes that you want to deactivate.

5.       Choose Actions and the action you want to perform.

 

Leaving content frame