Update Index Statistics

SQL Server maintains statistics on the distribution of the key values in each index and uses these statistics to determine which indexes to use in query processing. Query optimization depends on the accuracy of the distribution steps. Use Update Index Statistics in the following situations:

• If you made a significant change in the key values in the index

• If you add (for example, as a result of Data Migration), change, or remove a large amount of data in an indexed column (that is, if the distribution of key values changed)

• If you truncated the table using the TRUNCATE TABLE statement and then repopulated it

To run Update Index Statistics, right-click in the left column of the main Server Manager window and select Update Index Statistics. When the update finishes, a dialog box appears stating "Index statistics updated." Click OK.