Builds a unique index. Called by CREATE INDEX statement
This operation was introduced in Oracle 8.0.4
This operation is implemented in the following versions
|
This operation can only be observed by using EXPLAIN PLAN to populate the plan table. It does not appear in AUTOTRACE or V$SQL_PLAN
This example was developed using Oracle 9.2.0.1 on Windows 2000
This example requires the following table definition
CREATE TABLE t1 (c1 NUMBER);
The table does not need to be analysed
The statement
EXPLAIN PLAN FOR CREATE UNIQUE INDEX i1 ON t1 (c1);
generates the following execution plan
0 CREATE INDEX STATEMENT Optimizer=CHOOSE 1 0 INDEX BUILD (UNIQUE) 2 1 SORT (CREATE INDEX) 3 2 TABLE ACCESS (FULL) OF 'T1'