You display information about damaged, deactivated, and unused indexes.
You are logged on to the database as a database user.
You have the INDEX privilege for at least one table.
More information: SQL Reference Manual, Privilege Specification (privilege_specification)
In the explorer, expand the schema to which the indexes belongs.
In the context menu of the Indexes folder, choose Show Indexes.
Specify the indexes to be displayed:
Option |
Description |
---|---|
None |
All indexes from the selected schema are displayed. |
Only Bad Indexes |
Only damaged indexes are displayed. |
Only Disabled Indexes |
Only disabled indexes are displayed. |
Only Unused Indexes |
Only unused indexes are displayed (INDEXUSED=0). |
Choose (Refresh).
Property |
Description |
---|---|
Type |
Indicates whether or not the index is Unique |
Index Used |
Indicates how often the system has used the index |
Index Used Reset Time |
Time when the counters for index use were reset |
File State |
Indicates whether the index is damaged |
Disabled |
Deactivated |