3.5 Managing Indexes
An index is an optional structure associated with tables and clusters. Use Object Browser to create, view, or drop an index.
You can create indexes on one or more columns of a table to speed access to data on those columns.
- Creating an Index
Create an index using Object Browser. - Viewing an Index
Select an index from the Object Tree and access tabs in the Object Detail View. - Dropping an Index
Select an index from the Object Tree pane and click Drop on the Object Details tab.
Parent topic: Managing Database Objects with Object Browser
3.5.1 Creating an Index
Create an index using Object Browser.
To create an index:
Parent topic: Managing Indexes
3.5.2 Viewing an Index
Select an index from the Object Tree and access tabs in the Object Detail View.
To browse an index:
- In Object Browser, Object Tree, expand Indexes and select a index to view.
- The Object Detail View appears and displays the following tabs:
- Object Details - Displays the index
name, index type, table owner, table name, table type, uniqueness,
compression, prefix length, tablespace name, status, last analyzed and also
a listing of the indexed columns. Available actions include:
- Disable
- Drop
- Rebuild
- Refresh
- Statistics - Displays collected
statistics about the current view, including the number of rows, the
compression status (enabled or disabled), and when the data was last
analyzed. Available actions include:
-
Gather Statistics - Run a background process that gathers index statistics using
DBMS_STATS
. Clicking Gather Statistics displaysGather statistics in progress...
in the Last Analyzed column value.Click Refresh to get the index statistics information. If the background process finishes, the statistics information displays with Last Analyzed column value updated.
- Refresh - Refresh queries
statistics information gathered already from
USER_INDEXES
view.
-
- DDL - Displays the DDL necessary to re-create this index. Available actions include:
- Download
- Refresh
- Object Details - Displays the index
name, index type, table owner, table name, table type, uniqueness,
compression, prefix length, tablespace name, status, last analyzed and also
a listing of the indexed columns. Available actions include:
Parent topic: Managing Indexes
3.5.3 Dropping an Index
Select an index from the Object Tree pane and click Drop on the Object Details tab.
To drop an index:
Parent topic: Managing Indexes