Small. Fast. Reliable.
Choose any three.
REINDEX

reindex-stmt:

REINDEX schema-name . index-name table-name collation-name

R-52173-44778:[The REINDEX command is used to delete and recreate indices from scratch. ] This is useful when the definition of a collation sequence has changed, or when there are indexes on expressions involving a function whose definition has changed.

R-47362-07898:[If the REINDEX keyword is not followed by a collation-sequence or database object identifier, then all indices in all attached databases are rebuilt. ]

R-45878-07697:[If the REINDEX keyword is followed by a collation-sequence name, then all indices in all attached databases that use the named collation sequences are recreated. ]

R-49616-30196:[Or, if the argument attached to the REINDEX identifies a specific database table, then all indices attached to the database table are rebuilt. ] R-58823-28748:[If it identifies a specific database index, then just that index is recreated. ]

R-35892-30289:[For a command of the form "REINDEX name", a match against collation-name takes precedence over a match against index-name or table-name. ] This ambiguity in the syntax may be avoided by always specifying a schema-name when reindexing a specific table or index.

This page last modified on 2022-01-08 05:02:57 UTC