使用复合排序的嵌套循环联接(NLJOIN)。
以下是在执行嵌套循环联接的第一步时将发生的操作。
Here's what happens at execution time for the first leg of the nested loop join.
因此，在图7中优化器选择排序嵌套循环联接的复合物。
Therefore, in Figure 7 the optimizer chooses to sort the composite for the nested loop join.
而且，嵌套循环联接方法用于联接源表与目标表。
Also, the nested loop join method is used to join the source and target tables.
与嵌套循环联接相反，索引不再是非常重要的了。
Contrarily to the nested loop join, indexes are no longer so important.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
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.
如前所述，按顺序的输入对于合并扫描联接是必不可少的，但其无需嵌套循环联接。
As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.
因此，当与嵌套循环联接比较时，合并扫描联接可能对于排序输入产生成本。
So when compared to a nested loop join, the merge scan join may incur the cost for sorting the inputs.
因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共4个节点)。
Because of how nested loop joins work, the second leg (there are four nodes) is executed per outer table record.
该联接操作的结果就成为第一个联接操作输入到第二个联接操作（也是一个嵌套循环联接）。
The result of that join operation then becomes the first input to the second join operation (also a nested loop join).
要了解嵌套循环联接的更多信息，请参考参考资料部分中针对您的DB 2平台的适当的信息中心链接。
For more information about nested loop joins, refer to the appropriate information center link in the Resources section for your DB2 platform.
在之前的部分您已经了解了一种类型的访问方法，即索引扫描(IXSCAN)，和一种类型的联接方法，即嵌套循环联接(NLJOIN)。
In the previous section you learned about one type of access method, index scan (IXSCAN), and one type of join method, nested loop join (NLJOIN).
在之前的部分您已经了解了一种类型的访问方法，即索引扫描(IXSCAN)，和一种类型的联接方法，即嵌套循环联接(NLJOIN)。
In the previous section you learned about one type of access method, index scan (IXSCAN), and one type of join method, nested loop join (NLJOIN).
应用推荐