Difference between revisions of "REINDEX"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=REINDEX=
 
 
 
 
==Class==
 
==Class==
 
Indexing
 
Indexing
Line 15: Line 12:
  
 
==See Also==
 
==See Also==
[[INDEX]], [[USE]], [[SET ICACHE]], [[SET INDEX]], [[SET UNIQUE]]
+
[[INDEX]], [[SET ICACHE]], [[SET INDEX]], [[SET UNIQUE]], [[USE]]
  
  
Line 42: Line 39:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 +
[[Category:Indexing]]
 +
[[Category:Indexing Commands]]

Revision as of 16:24, 1 June 2009

Class

Indexing


Purpose

Rebuild all of the active index files


Syntax

REINDEX [ALL] [UNIQUE]


See Also

INDEX, SET ICACHE, SET INDEX, SET 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 Database Server, Recital Mirage Server, Recital Terminal Developer