3 ms·
> Are CTEs an optimization barrier in MSSQL? They are not. They are, however, in Postgres.
by wvenable 7y ago
> Are CTEs an optimization barrier in MSSQL?
They are not. They are, however, in Postgres.
- dragonwriter 7y agoThey are not (or at least less likely to be) in Postgres 12, as they are inlined in a wide variety of cases.
- jeltz 7y agoNot anymore since PostgreSQL 12 was released yesterday.