2 ms·
I think your assumption about inlining is essentially correct. As far as I know postgres was the last major rdbms to have an optimiser fence around CTEs.
by siddboots 6mo ago
I think your assumption about inlining is essentially correct. As far as I know postgres was the last major rdbms to have an optimiser fence around CTEs.
- nraynaud 6mo agoI concur, “the Germans” have created an algorithm that completely “see through” subqueries/CTEs when planning a query. The way the query is written has no bearing on the execution.
- atombender 6mo agoBy the Germans, as you referring to Thomas Neumann's database group at TMU, Munich?
- atombender 6mo ago*TUM (Technical University of Munich).