Begin figure description. The figure shows the two steps in a join operation:
  1. The initial composite table TJ is joined with the new table TK with a nested loop join.
  2. The composite table, which is the work file result of the join in the first step, is joined with a second new table TL. Db2® performs a merge scan join and a sort to produce the final result of the two-step join operation.
End figure description.