Legible and efficient SQL, with CTEs | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		Legible and efficient SQL, with CTEs (iron.io)
		1 point by ThatMightBePaul on Sept 4, 2015 \| hide \| past \| favorite \| 1 comment

jgavris on Sept 4, 2015 [–]

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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact