Optimizing an Index

Pre-8.1

In pre-8.1 to optimize an index, you use CTX_DDL.OPTIMIZE_INDEX and specify one of five different optimizing methods.

8.1.5

In 8.1 to optimize an index, you use the ALTER INDEX command in SQL with the REBUILD parameter. You can optimize the index in either fast or full mode.

8.1.6

In 8.1.6, in addition to optimizing with ALTER INDEX, you can use CTX_DDL.OPTIMIZE_INDEX to optimize the index from PL/SQL.

See Also: To learn more about optimizing the index with ALTER INDEX and CTX_DDL.OPTIMIZE_INDEX, see the Oracle8i interMedia Text Reference.