In your system AUTO UPDATE STATISTICS is on and can you tell me on which basis UPDATE STATISTICS” triggered?

[Joey]

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.

[Andrew]

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.