ALTER INDEX STATEMENT

Description

ALTER INDEX statement

Versions

This operation is implemented in the following versions

8.1.7
9.0.1
9.2.0
10.1.0
10.2.0

Example

This example was developed using Oracle 9.2.0.1 on Windows 2000

This operation cannot be detected using AUTOTRACE. Use EXPLAIN PLAN instead 

    CREATE TABLE t1 (c1 NUMBER);
    CREATE INDEX i1 ON t1 (c1);

    EXPLAIN PLAN FOR ALTER INDEX i1 REBUILD;

This statement creates the following execution plan (utlxpls.sql) 

0     ALTER INDEX STATEMENT
1   0   INDEX BUILD (NON UNIQUE) I1
2   1     SORT (CREATE INDEX)
3   2       TABLE ACCESS (FULL) OF 'T1'