Purpose
This page provides the method to Update Statistics for MS SQL database
Applicable in CAST Version
Release | Yes/No |
|---|---|
| 7.2.x | ? |
| 7.0.x |  |
Details
Updating statistics for one table or view
UPDATE STATISTICS ON < table_name > [ . <index_name> ] WITH FULLSCAN {, NORECOMPUTE }
For more information: http://msdn.microsoft.com/fr-fr/library/ms187348.aspx
Updating statistics for the whole database
For a database, run the following queries
USE database_name
EXEC sp_updatestats
For more information: http://msdn.microsoft.com/en-us/library/aa260337%28SQL.80%29.aspx
Notes / Comments
Related Pages