REINDEX DATABASE

From Lianjapedia
Revision as of 10:45, 21 December 2012 by Yvonne.milne (Talk | contribs)

Jump to: navigation, search

Purpose

Rebuilds the indexes for each table in the active database or rebuilds the catalog index tags for a specified database

Syntax

REINDEX DATABASE [<database name>]

See Also

ADATABASES(), ALTER INDEX, ALTER TABLE, CLOSE DATABASES, CLOSE TABLES, COMPILE DATABASE, COPY DATABASE, CREATE DATABASE, CREATE INDEX, CREATE TABLE, CREATE VIEW, DBUSED(), DISPLAY DATABASE, DISPLAY INDEXES, DISPLAY SCHEMAS, DISPLAY TABLES, DROP DATABASE, DROP INDEX, DROP TABLE, GETENV(), INDEX, LIST DATABASE, LIST INDEXES, LIST SCHEMAS, LIST TABLES, OPEN DATABASE, PACK DATABASE, REBUILD DATABASE, SET AUTOCATALOG, SET EXCLUSIVE, USE

Description

The REINDEX DATABASE command rebuilds the indexes for each table in the active database.

Databases are opened using the OPEN DATABASE command.

If the <database name> is specified, the REINDEX DATABASE command will operate on the specified database's catalog file: the catalog's index tags will be rebuilt.

Example

open database southwind
reindex database
close databases
reindex database southwind