Repairs an index or full-text index.

Syntax

UPDATE INDEX table_reference.index_name

UPDATE FULLTEXTINDEX table_reference.index_name

Description

If an index seems out-of-date (this can happen in the embedded version of TurboDB, if the client application crashes), the index can be re-built using this command. Use the asterisk * for the index_reference to update all indexes of a table.

Note

The UPDATE FULLTEXTINDEX statement is available only for the new maintained full-text indexes for level 4 tables.

Example

UPDATE INDEX MyTable.*; UPDATE FULLTEXTINDEX MyTable.*