+---------------------------------+
|             REINDEX             |
+---------------------------------+
REINDEX [COMPACT]

-----------------------------------
Rebuilds open index files.
-----------------------------------

The REINDEX command updates index files.  Index files become outdated
when a database is opened without opening its corresponding index files
and changes are made to the index files' key fields.  When index files
become outdated they may be updated by REINDEXing.

All index files (.IDX or .CDX) open in the currently selected work area
are updated by REINDEX.  All tags in .CDX compound index files are also
updated.

Two types of .IDX index files are available in FoxPro - the
"traditional" .IDX index files, and the preferable compact .IDX index
files.  Compact .IDX index files are smaller, requiring less disk space;
commands or functions that utilize an index file (FIND and SEEK for
example) are significantly faster when a compact index file is used.
Compound index files make use of the compact index file technology to
create small, fast index files with multiple index entries.  FoxPro's
SQL SELECT command (which may use the traditional .IDX index files) are
optimized for use with compact index files.

Any index files created with the UNIQUE option of the INDEX command or
with UNIQUE SET ON retain their UNIQUE status when they are reindexed.

To REINDEX outdated index files, issue the command:

        USE <database> INDEX <outdated index or indexes>

and then issue REINDEX.

COMPACT
        FoxPro recognizes each index file type and reindexes accordingly.  You
may, however, convert traditional .IDX index files to compact .IDX index
files by including the COMPACT keyword.

-----------------------------------

See Also:  INDEX, SET INDEX, SET UNIQUE, SYS(14) Index expression,
SYS(21) Master index number, SYS(22) Master tag/index name, SYS(2021)
Filtered index expr, USE

-----------------------------------