← All presentations

Discover the Hidden Mysteries of Common Table Expressions

Download

Abstract

Although it has been around for some time, the Common Table Expression (CTE) has been a complete mystery to many. As a result, there are many misunderstood myths and assumptions surrounding them. This session will explore CTEs, what they are, what they are not, and how they work. We’ll look at situations where they can help improve code clarity and performance, especially when compared side-by-side to usual methods. We’ll also identify scenarios where CTEs are incorrectly used, causing hidden performance problems.

Presented at:

  • SQL Saturday #745, Indianapolis, IN on Aug 11, 2018