Ideas how to gather optimizer stats
I'm having an issue with stale optimizer stats for some SQLs that are run in a batch process.
The problem is that the process runs many times during the day - sometimes 20 to 30 times.
And each time, the tables are updated, i.e. rows are inserted or deleted, etc.
So eventually the optimizer stats for those tables become stale and the performance
of the SQLs start to slow down (a lot).
Any ideas how best to gather the optimizer stats on the tables so they
don't become stale when the batch process runs each time?
The problem is that I also can't add/modify the code in the batch process because it is delivered by the vendor as is.
Any suggestions are greatly appreciated.
Click Here to Expand Forum to Full Width