How to update statistics (Query Analyzer)

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 Graphical Execution Plan automatically selects the appropriate database and table.
   
   
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

Graphically Displaying the Execution Plan Using SQL Query Analyzer

Statistical Information