Begin figure description. The figure shows
the two steps in a join operation:
- The initial composite table TJ is joined with the new table TK with a nested loop join.
- 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.