How to update statistics (Query Analyzer)

To update statistics

1. On the Query menu, click Show Execution Plan.
2. Execute the Transact-SQL script in the query pane.
3. In the result pane, click the Execution Plan tab.
4. Right-click the icon of the physical operator that suggests that statistics need to be updated, and then click Manage Statistics.... The database and table that the Graphical Execution Plan suggests need updated statistics are automatically selected.
5. Optionally, in Database and Table, click the name of a different database and table on which to update the statistics.
6. Click Update....
7. In Name, select the statistics to be updated.
8. Optionally, in Amount of data to sample, select:
   • Default to let Microsoft® SQL Server™ determine the number of rows to sample automatically.
   • Sample all the data to instruct SQL Server to sample all of the data in the table.
   • Sample % of the data and enter a percentage of data to sample to base the statistics on.
   • Sample rows and enter the number of rows to sample to base the statistics on.
9. Optionally, in Update statistics options, select:
   • Include columns to update statistics on columns as well as indexes.
   • Do not automatically recompute statistics (not recommended) to prevent SQL Server from updating statistics automatically as the data is updated.
10. Optionally, click Edit SQL... to view and edit the Transact-SQL statement used to create or update the statistics.

See Also