Forum Stats

  • 3,825,247 Users
  • 2,260,486 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:

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

Lothar FlatzgaurddbaNenad Noveljic
3 votes

Active · Last Updated