I've always thought of CTEs as a code organisation tool, not an optimisation too... | Hacker News

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

		yen223 3 days ago \| parent \| context \| favorite \| on: Good CTE, Bad CTE I've always thought of CTEs as a code organisation tool, not an optimisation tool. The fact the some rdbms treats them as an optimisation fence was a bug, not a feature.

		help

solumunus 3 days ago | [–]

Improved readability is definitely the primary benefit.

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