[nraynaud]

I 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]

By the Germans, as you referring to Thomas Neumann's database group at TMU, Munich?

[atombender]

*TUM (Technical University of Munich).