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