SQL-Rebuild-Index.adoc

SQL - REBUILD INDEX

Rebuilds automatic indexes.

Syntax

REBUILD INDEX <index-name>

• <index-name> It is the index name that you want to rebuild. Use * to rebuild all automatic indexes. Quote the index name if it contains special characters like square brackets.

Note	During the rebuild, any idempotent queries made against the index, skip the index and perform sequential scans. This means that queries run slower during this operation. Non-idempotent commands, such as INSERT, UPDATE, and DELETE are blocked waiting until the indexes are rebuilt.

Note	During normal operations an index rebuild is not necessary. Rebuild an index only if it breaks.

Examples

• Rebuild an index on the email property on the type Profile:

ArcadeDB> REBUILD INDEX `Profile[email]`

• Rebuild all indexes:

ArcadeDB> REBUILD INDEX *

For more information, see:

• CREATE INDEX

• DROP INDEX

• Indexes