Updated: April 19, 2023

Recreate indexes from scratch


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


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: