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. Click Delete.
  7. Confirm the deletion.
See Also
Graphically Displaying the Execution Plan Using SQL Server Query Analyzer Statistical Information

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.