Statistics updates

Update statistics regularly for accurate query plans. Use the following command to execute updates:

EXEC sp_updatestats;
-- or for a specific table
UPDATE STATISTICS [YourTableName];

You can also manage statistics updates using Ola Hallengren’s automation scripts. For additional information, see the Downloads page.