2.5 Managing Indexes
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.
- Creating an Index
Create an index using Object Browser. - Browsing an Index
Select an index from the Object Selection pane and view different reports about the an index. - Reports for Indexes
Alternative views available when browsing an index in Object Browser. - Dropping an Index
Select an index from the Object Selection pane and click Drop.
Parent topic: Managing Database Objects with Object Browser
2.5.1 Creating an Index
Create an index using Object Browser.
To create an index:
Parent topic: Managing Indexes
2.5.2 Browsing an Index
Select an index from the Object Selection pane and view different reports about the an index.
To browse an index:
Parent topic: Managing Indexes
2.5.3 Reports for Indexes
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
Parent topic: Managing Indexes
2.5.4 Dropping an Index
Select an index from the Object Selection pane and click Drop.
To drop an index:
Parent topic: Managing Indexes