Updating Index Statistics With Full Table Scan

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