Schedule autoupdate statistics

I’d recommend the following:

1) Turn autoupdates off (they cause perf overhead) and opening up the Fill Factor in the index from 80% (default) to 50% or lower, which will leave more room to grow the index.

2) Schedule autoupdate statistics runs cyclicly as needed.

Leave a Reply

You must be logged in to post a comment.