I pointed out out frequency beacuse, if you run gather stats job weekly once and still face performance problems and after analyzing it seemsexplain plan is not good enough because of volume of data updated or inserted, then you need to gather stats more than once a week.
Hope this clarifies.




Reply With Quote