Creating Indexes
Creating and Using Tables
3-18 Oracle Database 2 Day Developer's Guide
In this section, you will learn how to add different types of indexes to the tables you
created earlier.
To create an index using the SQL Developer interface:
Follow these steps to create a new index for the
evaluations
table.
1.
In the Connections navigation hierarchy, right-click the
evaluations
table.
2.
Select Index and then select Create Index.
Alternatively, in the Connections navigation hierarchy, you can right-click Indexes
and select New Index.
3.
In the Create Index window, enter the following parameters:
Ensure that the Schema is set to
HR
.
Set the Name to
EVAL_JOB_IX
.
Click the
Add Column Expression
icon, which looks like a 'plus' sign.
Set the Column Name or Expression to
JOB_ID
.
Set the Order to
ASC
.
Click OK.
