Legible and efficient SQL, with CTEsiron.io 1 pointThatMightBePaul11 years ago1 commentSaveHideCopy link On HNComments−jgavris11yLegible? 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.
Comments
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.