Similarly, joining a CTE to itself can also be problematic. In that case materializing to a temp table can be faster.