602SQL Documentation Index  

Rebuilding indexes

A failure during an actualization operation when secure transactions are disabled may result in table indices damage. Indices errors cause incorrect record selection based on specified criteria or incorrect sorting. You can check whether the indices are damaged by the Check_indices function. If it's discover that the error is reduced only on indexes, it's possible to rebuild them.

The indexes can be rebuilt by the table popup menu action Rebuild indexes. Alternatively the same can be achieved by calling the Enable_index function twice, first with the FALSE parameter and then with the TRUE parameter.

Indexes are also rebuilt when the database consistency is being repaired.