Is there any performance gain using a CTE over a derived table?
views:
2144answers:
2
+2
A:
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.
Cade Roux
2008-11-20 19:14:14
+3
A:
From what I have read and my limited use of them, no, they are just easier to read and can reference themselves.
Potbelly Programmer
2008-11-20 19:14:44