Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.
因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共4个节点)。
As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.
如前所述，按顺序的输入对于合并扫描联接是必不可少的，但其无需嵌套循环联接。
However, the benefit of the merge scan join is that the inner table does not have to be scanned repeatedly as it does for nested loop joins.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
For more information about nested loop joins, refer to the appropriate information center link in the Resources section for your DB2 platform.
要了解嵌套循环联接的更多信息，请参考参考资料部分中针对您的DB 2平台的适当的信息中心链接。
The optimizer will choose nested-loop joins if.
如果满足下列条件，优化器将选择嵌套循环连接。
The optimizer will choose nested-loop joins if.
如果满足下列条件，优化器将选择嵌套循环连接。
应用推荐