3 ms·In SQL Server, CTEs eventually slow down then temp tables win because they can have indexes.by j_s 12y agoIn SQL Server, CTEs eventually slow down then temp tables win because they can have indexes.