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.

Related concepts
Predicate transformations
Transitive closure
View transformations
Outer join transformations
Sort avoidance
Aggregate processing