To
update index statistics:
Click the Index object in the tree. A list of all the indexes in the database is displayed.
Click the Statistics tab. The Statistics page is displayed.

If you want to change the percentage of the data used to calculate updated statistics, select the Sample Ratio box and enter a percentage to sample.
Click the Update Statistics button. The following window is displayed.

Click OK.

Click OK.
Related topic: