DB2 LUW: how to influence query planner's choice of join
Hash joins require an "equijoin predicate".  So I rewrote the query as an explicit join (instead of IN...(subselect)), and instead of using A.key = B.key as the join condition, I used A.key > B.key - 1 AND A.key &lt; B.key +1.