March 6, 2013 at 1:48 am
Hi
Does the option "Auto Update Statistics Asynchronously" work for update ,delete and insert statement or it is just used for select?
I mean if I enable this option ,after update ,delete and insert would the statistics be updated?
Also I have a nightly job that update statistics with full scan.
March 6, 2013 at 4:57 am
That setting only specifies whether your queries will wait for stats to be compiled or will use stale stats.
The setting to control auto update is "AUTO UPDATE STATISTICS". Auto update is only triggered by select statements once data modification thresholds have been reached.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy