Rebuilds automatic indexes.
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
DELETEare blocked waiting until the indexes are rebuilt.
Rebuild an index on the
nickproperty on the class
REBUILD INDEX Profile.nick
Rebuild all indexes:
REBUILD INDEX *
For more information, see