REINDEX

Topic group Related topics Example

Regenerates all open index files in the current work area.

Syntax

REINDEX

Description

Use REINDEX to manually regenerate all open indexes in the current work area. In a normal application, indexes remain open as long as their tables are open. These indexes are automatically updated whenever there is a change to the table, so there is no need to manually REINDEX.

You would use REINDEX if your application uses non-production .MDX files or .NDX files that are not always open. To update these indexes, open them with the corresponding table and issue REINDEX.

You might also use REINDEX if you suspect that the index files have been damaged. REINDEX rebuilds the entire index file from scratch.

You must have exclusive use of a table to REINDEX it.

OODML

Use the Database object’s reindex( ) method.