How to do Incremental statistics on auto_created stats(WA) in SQL server? I know I can do this for the non auto_created stats (indexed column) either by rebuilding index on the table or at DB level.
Is there any way to achieve this on auto_created stats(WA) also?
The underlying issue is-
On a good day query runs in 10 sec and on a bad day it take 5 min. This query uses 15 columns in a join on a large table. This table is partitioned. The only difference I found that on the bad run stats were also updated on those 15 columns at the same time query is running. please advise.
SQL Server 2017: is_auto_create_stats_on= True; is_auto_create_stats_incremental_on= False; is_auto_update_stats_on= True; is_auto_update_stats_async_on= False;