How to minimize High Residual IO
The statistics are the roadmap the optimizer uses when building a query plan. Outdated statistics are the equivalent to navigating in a new town with a 10-year old paper map. Current statistics are like using your map app on your smartphone to navigate to the same location. Which would you choose?
I've added a maintenance task to update statistics nightly. Thanks!
,That was exactly right. I updated statistics and problem solved.
I've scheduled a nightly task to update them now.