Author Topic: In your system AUTO UPDATE STATISTICS is on and can you tell me on which basis UPDATE STATISTICS” triggered?  (Read 240 times)

Offline Joey

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
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.



Offline Andrew

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: System AUTO UPDATE STATISTICS
« Reply #1 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.


 

Sitemap 1 2 3 4 5 6 7 8 9