Webastor - Programming Tips and Tricks

Programming language => Sql => Topic started by: Joey on October 27, 2014, 10:35:41 AM

Title: In your system AUTO UPDATE STATISTICS is on and can you tell me on which basis UPDATE STATISTICS” triggered?
Post by: Joey on October 27, 2014, 10:35:41 AM
Hello, I would like to ask you a question. Thank you How we do, in your system auto update statistics is on and can you tell me on which basis “update statistics” triggered? Thank you very much for helping me but it is not very urgent.
Title: Re: System AUTO UPDATE STATISTICS
Post by: Andrew on December 09, 2017, 05:17:54 PM
Check the DB setting for "Auto Update Statistics Asynchronously" . Note that Update Statistics gets triggered during the first select after such insert/update but not immediate after the insert/update finishes.