Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

REORGANIZE INDEX

If a text column is often updated, searching the index can become inefficient. To make searching effient again, the index has to be reorganized. Although Text Extender recognizes when an index needs to reorganized and does so in the background automatically, there may be situations that require an index to be reorganized manually using REORGANIZE INDEX. You can use the command GET INDEX STATUS to find out if an index needs to be reorganized.

Authorization

None.

Command syntax

>>-REORGANIZE INDEX--table-name--------------------------------->
 
>-----+-----------------------------+--------------------------><
      '-HANDLE--handle-column-name--'
 

Command parameters

table-name
The name of the text table in the connected database whose index is to be reorganized. The name must include an explicit schema name (qualifier) unless the schema name is the same as your user ID.

HANDLE handle-column-name
The name of the handle column whose index is to be reorganized.

Usage notes

For a multi-index table, you must specify a handle column name.

Although searches can be made on the index while REORGANIZE INDEX is running, index updates cannot.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]