[DangitBobby]

That's mainly true because you don't have the benefit of an index when you join on a CTE, isn't it?

[jansommer]

It'a slow even without indexes. In other cases, where the CTE is used multiple times in the same query, it can be faster