How to delete statistics (Query Analyzer)

How to delete statistics (Query Analyzer)

To delete 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 represents the table containing the statistics that need to be deleted, and then click Manage Statistics.
   
   
5. Optionally, in Database and Table, click the name of a different database and table on which to delete the statistics.
   
   
6. In Existing statistics, click the name of the statistic to delete, and then click Delete.
   
   
7. Confirm the deletion.

See Also

Graphically Displaying the Execution Plan Using SQL Query Analyzer

Statistical Information