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

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

Answers


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.


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


Need Your Help

Create a Matrix with conditions

matrix sas

I am struggling to create two matrix in SAS based on certain conditions.

Add form to existing page with an ajax request

javascript php jquery forms

I haven't started coding this yet, so I don't have anything to show. I'm still trying to work out HOW to start. I will have a page that will have various forms on it depending on what the visitor is

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.