CTEs are often slower than using temp tables with indexes.