That's great news, thanks Karl! On my part, I've been digging deeper into the execution plans of the two queries and I've made a similar observation of the ORDER BY skewing the original query's plan significantly. However, I have yet to figure out why the same ORDER BY clause doesn't have a similar impact on the modified query that uses JOIN. I'll look into this a bit more over the weekend.
Best regards, Aeham
