Difference between revisions of "REINDEX"
Yvonnemilne (Talk | contribs) |
Barrymavin (Talk | contribs) (→Products) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Rebuild all of the active index files | Rebuild all of the active index files | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[CANDIDATE()]], [[CLOSE INDEX]], [[COPY INDEXES]], [[COPY TAG]], [[CREATE VIEW]], [[DELETE TAG]], [[DBXDESCEND()]], [[DESCEND()]], [[DTOS()]], [[FIND]], [[FOR()]], [[INDEX]], [[LOOKUP()]], [[MDX()]], [[LTOS()]], [[RLOOKUP()]], [[SEEK]], [[SEEK()]], [[SET FASTINDEX]], [[SET INDEX]], [[SET ORDER]], [[SET PCUNIQUE]], [[SET UNIQUE]], [[STR()]], [[STRZERO()]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[UNIQUE()]], [[USE]] | + | [[CANDIDATE()]], [[CLOSE INDEX]], [[COPY INDEXES]], [[COPY TAG]], [[CREATE VIEW]], [[DELETE TAG]], [[DBXDESCEND()]], [[DESCEND()]], [[DTOS()]], [[FILTER()]], [[FIND]], [[FOR()]], [[ICACHE()]], [[INDEX]], [[LOOKUP()]], [[MDX()]], [[LTOS()]], [[RLOOKUP()]], [[SEEK]], [[SEEK()]], [[SET FASTINDEX]], [[SET FILTER]], [[SET ICACHE]], [[SET INDEX]], [[SET ORDER]], [[SET PCUNIQUE]], [[SET UNIQUE]], [[STR()]], [[STRZERO()]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]], [[UNIQUE()]], [[USE]] |
==Description== | ==Description== | ||
| Line 35: | Line 31: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Indexing]] | [[Category:Indexing]] | ||
[[Category:Indexing Commands]] | [[Category:Indexing Commands]] | ||
| + | [[Category:Table Basics]] | ||
| + | [[Category:Table Basics Commands]] | ||
| + | [[Category:Data Commands]] | ||
Latest revision as of 10:05, 30 November 2009
Purpose
Rebuild all of the active index files
Syntax
REINDEX [ALL] [UNIQUE]
See Also
CANDIDATE(), CLOSE INDEX, COPY INDEXES, COPY TAG, CREATE VIEW, DELETE TAG, DBXDESCEND(), DESCEND(), DTOS(), FILTER(), FIND, FOR(), ICACHE(), INDEX, LOOKUP(), MDX(), LTOS(), RLOOKUP(), SEEK, SEEK(), SET FASTINDEX, SET FILTER, SET ICACHE, SET INDEX, SET ORDER, SET PCUNIQUE, SET UNIQUE, STR(), STRZERO(), TAG(), TAGCOUNT(), TAGNO(), UNIQUE(), USE
Description
The REINDEX command rebuilds all of the index files associated with the currently active table. The disk space previously occupied by the index files is not released, but merely reinitialized. Any FILTER is ignored in the reindexing process.
REINDEX cannot be executed if the table or tables in questions are not opened exclusively. Increasing the size of the index key 'cache' can optimize the performance of the REINDEX operation. The SET ICACHE command can be used to accomplish this.
ALL
If the ALL option is specified, all indexes associated with each open table will be reindexed.
UNIQUE
If the UNIQUE option is specified, or SET UNIQUE ON is in effect, then duplicate keys are discarded from the index files.
Example
set exclusive on use patrons index events, names, dates reindex
Products
Recital Server, Recital
