Monitoring Databases
«Prev
Maintaining Database Statistics
Update Statistics Syntax
- Table – The table for which you are updating statistics.
- Index – A specific index on the table for which you are updating statistics.
- Statstics_name [,…n] – One or more statistic groups.
- FULLSCAN – Tells the create statistics command to scan the whole table when creating the statistics.
- Sample number PERCENT – Allows you to specify how much of the table to scan.
- ALL – Tells SQL Server to update statistics on both index and statistic groups.
- COLUMNS – Tells SQL Server to only update statistics on statistic groups.
- INDEX – Tells SQL Server to only update statistics on indexes.
- Norecompute – Stops SQL Server from automatically updating statistics on this statistics group.