Oracle8i interMedia Text Migration
Release 2 (8.1.6)

A77061-01

Library

Product

Contents

Index

Prev Up Next

Indexing, 10 of 14


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


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index