Auto Update or Auto Create Statistics Disabled
When the auto create statistics or auto update statistics options are enabled, SQL Server collects statistics on the distribution of values in columns. Accurate statistics allow the optimizer to create more efficient query plans; which should result in better performance.
Both auto create statistics, and auto update statistics should be enabled.
Any suggestion from Aireforge should be thoroughly tested before being implemented into production.
Database Properties (Options Page) | Microsoft Docs