Legible and efficient SQL, with CTEs

Posted by ThatMightBePaul on Friday September 04, 2015 @04:57PM
from the iron.io dept.

http://www.iron.io/blog/2015/09/legible-efficient-sql-with-ctes.html

( 1 comment | on HN )

Re:Legible and efficient SQL, with CTEs by jgavris on Friday September 04, 2015 @05:13PM (#10172900)

Legible? Absolutely. But it's important to keep in mind that CTE's are optimization fences. Optimizations like predicate pushdown are not currently available. More complicated queries may benefit from being rewritten with subqueries.

[ Parent | on HN ]