Joins

Joins are generally a good option in the following scenarios:

If supporting indexes are available and most rows hook up in the join
If the join results in no extra rows returned then the DISTINCT can also be avoided

Joins can let DB2 pick the best table access sequence, and apply predicate transitive closure.