Hacker News new | past | comments | ask | show | jobs | submit login

> Are CTEs an optimization barrier in MSSQL?

They are not. They are, however, in Postgres.




They are not (or at least less likely to be) in Postgres 12, as they are inlined in a wide variety of cases.


Not anymore since PostgreSQL 12 was released yesterday.




Consider applying for YC's Spring batch! Applications are open till Feb 11.

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

Search: