Open topic with navigation
Index statistics are not generated by default. Index statistics are useful both to the Query Optimizer and to the user. They tell us more about the index and its effectiveness with the particular data on which it is executing. The user must run
ANALYZE to generate statistics for a table or index. Running
ANALYZE is required whenever significant changes are made to the contents of a table or index. The
ANALYZE command can be run on an index or on a table. See ANALYZE and examples below for more information.