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
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.