REINDEX

Recreate indexes from scratch

Synopsis:

 REINDEX collation-name | ( [database-name .] table-name | index-name ) 

Description:

The REINDEX command deletes and recreates indexes from scratch. This is useful when the definition of a collation sequence has changed.

The scope of the affected database indexes depends on the type of database object given to the command, as summarized in the following behavioral rules: