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.
Scripting on this page tracks web page traffic, but does not change the content in any way.