Question: are ctes faster than temp tables?
Answer: If you are joining multiple tables with millions of rows of records in each, CTE will perform significantly worse than temporary tables. Temp tables are always on disk - so as long as your CTE can be held in memory, it would most likely be faster (like a table variable, too).