Flattening VALUES subqueries

Derby flattens VALUES subqueries to improve performance.

Parent topic: Subquery processing and transformations

Related concepts

Materialization

Flattening a subquery into a normal join

Flattening a subquery into an EXISTS join

DISTINCT elimination in IN, ANY, and EXISTS subqueries

IN/ANY subquery transformation