<< Click to Display Table of Contents >> Navigation:  »No topics above this level« REINDEX TABLE

The REINDEX TABLE statement allows tables that use structural indexes, such as CDX and NSX, to be re-indexed using existing index key and expression information. This is a very fast and efficient way ensure indexes are up-to-date and valid. Use the full table name with extension, for example: "MyTable.DBF"

Use ExecSQL from within in each Apollo interface to execute this statement.

Syntax:

REINDEX TABLE [tablename]

 

Examples:

/* For a FoxPro table, creates NAMES tag inside

CUSTOMER.CDX on "LAST+FIRST" */

REINDEX TABLE MyTable