Oracle8i interMedia Text Migration
Release 2 (8.1.6)

Part Number A77061-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index