Internal Language Transformations
Page 6 of 8

Outer Join Transformations

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