Forum Stats

  • 3,825,247 Users
  • 2,260,486 Discussions
  • 7,896,465 Comments

Discussions

Unnesting of scalar subqueries in select clause

Nenad Noveljic
Nenad Noveljic Member Posts: 11 Blue Ribbon

The optimizer currently doesn't unnest scalar subqueries in the select clause, even when feasible.

Here's a list of such cases:

https://nenadnoveljic.com/blog/correlated-subqueries-in-the-select-clause-2/

Such unnested subqueries must be executed for every row in the driving rowset.

Lothar FlatzgaurddbaNenad Noveljic
3 votes

Active · Last Updated