Subquery Processing and Transformations

Subqueries are notoriously expensive to evaluate. This section describes some of the transformations that Derby makes internally to reduce the cost of evaluating them.

• Materialization
• Flattening a Subquery into a Normal Join
• Flattening a Subquery into an EXISTS Join
• Flattening VALUES Subqueries