Allow recompile of BAQ cached query plans

Going to 600 we had several queries that would no longer run and just time-out. The only way to get them working again is to screw with them enough to get the cache plan to recompile. It’s somewhat time-consuming so a quick way to recompile the cache would be awesome!

Get out there and vote!
https://epicor-manufacturing.ideas.aha.io/ideas/ERP-I-171

What’s the SQL for this? Are you thinking of using a Query Hint of OPTION(RECOMPILE)?

2 Likes

Maybe add to the Actions -> Query Execution Settings an option to persist OPTION(RECOMPILE) or something with the BAQ.

2 Likes

That’s on the lines of what I’m thinking too.

Also allow us to turn on STATISTICS IO and STATISTICS TIME.