Heh, it’s probably been over a decade since I regularly had to do this sort of thing, but literally my first thought on seeing that query was “Hmmm, I’d try rew

Heh, it’s probably been over a decade since I regularly had to do this sort of thing, but literally my first thought on seeing that query was “Hmmm, I’d try rewriting that to force a different execution plan” and lo and behold, that was the answer. It’s kind of comforting that not all my experience is obsolete!