Outer join transformations

Derby transforms OUTER to INNER joins when the predicate filters out all nulls on the join column. This transformation can allow more potential query plans and thus better performance.

Related concepts
Predicate transformations
Transitive closure
View transformations
Subquery processing and transformations
Sort avoidance
Aggregate processing