Auto Update or Auto Create Statistics Disabled

Auto create statistics or auto update statistics is not enabled on this database. The Query Optimizer within SQL Server can automatically generate and maintain statistics on the distribution of values in columns. Accurate statistics enable the optimizer to create more efficient query plans; which will result in better performance.

Suggested Action

💡 Aireforge Advisor can automatically generate a script for this.

Ensure auto create statistics, and auto update statistics are enabled.

How to Enable Auto Update or Auto Create Statistics for a Database

USE [master]
GO
ALTER DATABASE [WhippetWorks] SET AUTO_CREATE_STATISTICS ON;
GO
ALTER DATABASE [WhippetWorks] SET AUTO_UPDATE_STATISTICS ON WITH NO_WAIT;
GO

Further Reading

Database Properties (Options Page) | Microsoft Docs