An index is an optional structure associated with tables and clusters. You can create, browse, drop an index and view reports.
You can create indexes on one or more columns of a table to speed access to data on those columns.
When you view an index in Object Browser, the Detail pane displays a report containing the index name, index type, table owner, table name, table type, uniqueness, compression, prefix length, tablespace name, status, last analyzed and a listing of the indexed columns.
Select an index from the Object Selection pane and view different reports about the an index.
To browse an index:
Alternative views available when browsing an index in Object Browser.
Table 2-4 describes all available reports for indexes.
Table 2-4 Available Reports for Indexes