Nested loop join (NLJOIN) with sort composite.
使用复合排序的嵌套循环联接(NLJOIN)。
Therefore, a total of eight records will be produced by the NLJOIN node.
因此，总共8条记录将通过NLJOIN节点产生。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
There is a nested loop join (NLJOIN, step 4) of the insert (step 5) to an index scan (IXSCAN, step 7).
其中有一个insert（步骤5）与索引扫描（步骤7）之间的嵌套循环连接（NLJOIN，步骤4 ）。
The NLJOIN node will eventually produce eight joined records as the output (output Cardinality value is 8).
NLJOIN节点将最终产生8条已联接的记录作为输出(输出基数值是8)。
Although IXSCAN (15) is a base access, it is dependent on NLJOIN (5), and so it can be ignored in the interim.
尽管IXSCAN(15)是基本访问，但是它依赖于NLJOIN(5)，所以可以忽略它。
Relational guidelines such as join, MSJOIN, NLJOIN, and HSJOIN can be used to specify the join order and the join type.
关系准则，比如join、MSJOIN、NLJOIN和HSJOIN都可以用来指定连接顺序和连接类型。
Similarly, the last leg in the access path graph is evaluated eight times, once for each record produced by the first NLJOIN node.
同样，访问路径图的最后一步要评估8次，通过第一个NLJOIN节点产生的每条记录都要评估一次。
As such, the NLJOIN does not act as a classical join with two input legs, but facilitates access to the XML data for the XSCAN operator.
同样地，NLJOIN并没有充当拥有两个输入的标准连接，而是协助XSCAN操作符来访问XML数据。
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)。
TBSCAN (4) — Since this is the same join predicate being resolved at NLJOIN (2), and there are no additional local predicates, we can ignore this operator.
TBSCAN(4)——因为这个连接断言和NLJOIN(2)分析出的相同，并且没有其他局部断言，可以忽略该操作。
TBSCAN (4) — Since this is the same join predicate being resolved at NLJOIN (2), and there are no additional local predicates, we can ignore this operator.
TBSCAN(4)——因为这个连接断言和NLJOIN(2)分析出的相同，并且没有其他局部断言，可以忽略该操作。
应用推荐