Managing Indexes

An index is an optional structure associated with tables and clusters. You can create indexes on one or more columns of a table to speed access to data on that table.

When you view an index in Object Browser, the Detail pane displays a report containing the index name, index type, table owner, table type, and a listing of the indexed columns.

Topics:

Creating an Index
Browsing an Index

Creating an Index

To create an view:

Navigate to Object Browser:
1. Click the SQL Workshop icon on the Workspace home page.
2. Click Object Browser.
  
  Object Browser appears.
Click Create.
From the list of object types, select Index.
Select a table and select the type of index you want to create. Available index types include:
- Normal - Indexes one or more scalar typed object attributes of a table
- Text - Creates a text index (Oracle Text)
Click Next.
Create the index definition. Specify an index name, select one or more columns to be indexed, and click Next.

A confirmation page appears. To view the SQL used to create the index, click SQL.
Click Finish.

Browsing an Index

To browse an index:

Navigate to Object Browser:
1. Click the SQL Workshop icon on the Workspace home page.
2. Click Object Browser.
  
  Object Browser appears.
From the Object list, select Indexes.
From the Object Selection pane, select an index.

The index appears displaying the index name, type, table owner, and table type as well as a listing of indexed columns.

Summary of Available Views

Click the tabs at the top of the page to view different reports about the index. Table 18-4 describes all available views.

Table 18-4 Available Views for Indexes

View	Description
Object Details	(Default) Displays the index name, index type, table owner, and table type as well as a listing of the indexed columns. Actions you can perform while viewing Object Details include: Disable - Disables the current index Drop - Drops the current index.x Rebuild - Rebuilds the current index
Statistics	Displays collected statistics about the current view, including the number of rows, sample size, when the data was last analyzed, and the compression status (enabled or disabled). Click Analyze to refresh the displayed statistics.
SQL	Displays the SQL necessary to re-create this index.

View

Description

Object Details

(Default) Displays the index name, index type, table owner, and table type as well as a listing of the indexed columns. Actions you can perform while viewing Object Details include:

Disable - Disables the current index
Drop - Drops the current index.x
Rebuild - Rebuilds the current index

Statistics

Displays collected statistics about the current view, including the number of rows, sample size, when the data was last analyzed, and the compression status (enabled or disabled). Click Analyze to refresh the displayed statistics.

SQL

Displays the SQL necessary to re-create this index.