BAQ Performance suddenly horrible

[Olga (Olga Klimova)]

Strange, Poor BAQ Performance?

That’s likely because you have a bad cache on your Query Plan. Try adding OPTION (RECOMPILE) to your query. This isn’t trivial to do but if you go to [image] Then add Order By 1 OPTION (RECOMPILE) persist in query [image] That may fix it, give it a shot.

or ORDER BY