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.
The database instance is in the operational state ONLINE.
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.