Archive

Archive for the ‘Update Statistics (Full TableScan)’ Category

Updating Index Statistics With Full Table Scan

March 9, 2010 Leave a comment

How to Update Index Statistics of a table with Full Table Scan.

UPDATE STATISTICS dbo.Tablename WITH FULLSCAN

The following example updates the table statistics group (collection) in the given table, forces a full scan of all rows in the given table, andĀ re-enables automatic statistical updating on the table.

In case u does not want to enable automatic statistical updating use NORECOMPUTEĀ option to disable the same.

UPDATE STATISTICS dbo.Tablename WITH FULLSCAN NORECOMPUTE