Running ANALYZE to Obtain Index Statistics

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.