SQL Server Performance: derived table vs. common table expression (CTE)

Question

Is there any performance gain using a CTE over a derived table?

score 3 · Accepted Answer · answered Nov 20 '08 at 19:14

I've used CTEs a lot and it does actually appear to run faster in some scenarios. The server was fairly well loaded, the variation in times on runs was pretty significant, and I can't believe the execution plan was that different, but it still seemed like the ones with the CTE performed better.

score 3 · Answer 2 · answered Nov 20 '08 at 19:14

3

From what I have read and my limited use of them, no, they are just easier to read and can reference themselves.

answered Nov 20 '08 at 19:14

Potbelly Programmer

91
1
4

SQL Server Performance: derived table vs. common table expression (CTE)

2 Answers2