Well, the "Auto. Create Stats" and also "Auto. Update Stats" could be a real pain; I recommend to disable it.
THe sufficiently maintain the required statistics you could implement a SQL Agent Job (or TSQL task for the MP) doing this:
use [MyNAVdb]goexec sp_updatestatsgo
exec sp_createstats 'indexonly'
To get rid of the already existing auto-stats, you could exec this script (part of the NAV/SQL Performance Toolbox)
declare @id int, @name varchar(128), @statement nvarchar(1000)declare stat
Leggi tutto il post...