Displaying Indexes 
You display information about damaged, deactivated, and unused indexes.
Prerequisites
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)
Procedure
In the explorer, expand the schema to which the indexes belong.
In the context menu of the Indexes folder, choose Show Indexes.
Specify the indexes to be displayed:
Indexes: Display Criteria 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).
Result
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 |