SQL-Rebuild-Index.md

SQL - REBUILD INDEXES

Rebuilds automatic indexes.

Syntax

REBUILD INDEX <index>

• <index> Defines the index that you want to rebuild. Use * to rebuild all automatic indexes.

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.

Examples

• Rebuild an index on the nick property on the class Profile:

  orientdb> REBUILD INDEX Profile.nick
  

• Rebuild all indexes:

  orientdb> REBUILD INDEX *
  

For more information, see

• CREATE INDEX
• DROP INDEX
• Indexes
• SQL commands