Recreate indexes from scratch


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


The REINDEX command is used to delete and recreate 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: