ANL7019I *** GUIDELINE: TO SELECT NESTED LOOP OR HYBRID JOIN INSTEAD OF THE MERGE SCAN, YOU CAN TRY THE OPTIMIZE FOR N ROWS CLAUSE TO MAKE THE Db2® OPTIMIZER THINK THAT THESE TABLES ARE SMALLER, AND THE RESULTING ANSWER SET IS ALSO SMALL. MS IS LIKELY SELECTED WHEN MORE ROWS WILL RESULT, OR WHEN NO INDEXES ARE PRESENT OR USABLE.