> What can I do to improve the performance of the regular query without using a CTE?
Why do you care ? When I find that I can write a SQL 3 different ways, I will go for the most
efficient one. So why not accept the CTE version of this SQL. Just curious.