Modifying Indexes
Creating and Using Tables
Creating and Using Database Objects 3-19
You have now created a new index
EVAL_JOB_IX
on the column
JOB_ID
in the
evaluations
table. You can see this index by finding it in the list of Indexes in the
Connections navigation hierarchy, or by opening the
evaluations
table and
browsing to the Indexes tab. The following script is the equivalent SQL statement for
creating this index.
CREATE INDEX eval_job_ix ON evaluations (job_id ASC) NOPARALLEL;
To modify an index using SQL Developer interface:
Follow these steps to reverse the sort order of the
EVAL_JOB_IX
index.
1.
In the Connections navigation hierarchy, the plus sign (+) to expand Indexes.
2.
Right-click
EVAL_JOB_IX
, and select Edit.
3.
In the Edit Index window, change Order to
DESC
.
Click OK.
