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 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 type, uniqueness, compression, prefix length, tablespace name, status, last analyzed and a listing of the indexed columns.
Topics:
To create an index:
On the Workspace home page, click SQL Workshop and then 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, which displays the SQL used to create the index.
To confirm, click Create Index.
To browse an index:
On the Workspace home page, click SQL Workshop and then 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, table type and a listing of indexed columns.
Click the tabs at the top of the page to view different reports about the index. Table 1-4 describes all available views.
Table 1-4 Available Views for Indexes
To drop an index:
On the Workspace home page, click SQL Workshop and then Object Browser.
Object Browser appears.
From the Object list, select Indexes.
From the Object Selection pane, select an index.
Under Object Details, click Drop.
To confirm, click Finish.