Nested loop join (NLJOIN) with sort composite.
使用复合排序的嵌套循环联接(NLJOIN)。
The second leg of the NLJOIN node is similar to that of the first table
NLJOIN节点的第二步类似于第一个表的第二步
Therefore, a total of eight records will be produced by the NLJOIN node.
因此，总共8条记录将通过NLJOIN节点产生。
Also, each probe into the inner input of both NLJOIN operations matches only one record.
此外，每个进入到两个NLJOIN操作的内部输入的探测只与一条记录相匹配。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
Looking at NLJOIN (8), which represents the entire function you see a three way ordered join.
我们看一下NLJOIN(8)，它表示整个函数，从中可以看到一个按三种方法排序的连接。
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 ）。
Thus the estimation for final the result set is one row only (NLJOIN (2)), which matches the real result.
因此结果集中最终的评估值只有一个(NLJOIN(2))，这是符合实际结果的。
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)，所以可以忽略它。
These eight qualifying records are then taken as the first input to the NLJOIN node immediately above the FETCH node.
然后用作第一个联接操作的这8条合格的记录将立即输入到在FETCH节点之上的NLJOIN节点。
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都可以用来指定连接顺序和连接类型。
The detailed information in the NLJOIN descriptor (also shown in Figure 6) shows that according to optimizer's estimate.
NLJOIN描述符上的细节信息(也显示在图6中)显示优化器的估计。
Since the OUTER of this NLJOIN, TBSCAN (2), is applying local predicates, you must also add the predicates to the count query.
因为该NLJOIN的outer即t BS CAN(2)应用于局部断言，必须将该断言增加到计数查询。
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节点产生的每条记录都要评估一次。
FETCH (13) and UPDATE (15) actually read and assign values to the outer of NLJOIN (9) overriding the defaults for the local variables.
FETCH(13)和UPDATE(15)实际上是读取NLJOIN(9)的外表的值，并赋上新值，覆盖本地变量的默认值。
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数据。
Based on guideline (c), you can ignore a separate count query for TBSCAN (4) as the join predicate being resolved is the same as in NLJOIN (2).
按照原则(c)，可以忽略tbs CAN(4)的单独count查询，因为解析的连接断言和NLJOIN(2)相同。
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)分析出的相同，并且没有其他局部断言，可以忽略该操作。
Start from the leftmost deepest operator, in this case, the OUTER of NLJOIN(2) which is TBSCAN(2), and the INNER which is TBSCAN(4), and then the join predicate itself which is NLJOIN(2).
从最左侧、最深的操作开始，在这里就是NLJOIN(2) 的OUTER即TBSCAN(2)，然后INNER 即 TBSCAN(4)，最后是连接断言本身即 NLJOIN(2)。
Start from the leftmost deepest operator, in this case, the OUTER of NLJOIN(2) which is TBSCAN(2), and the INNER which is TBSCAN(4), and then the join predicate itself which is NLJOIN(2).
从最左侧、最深的操作开始，在这里就是NLJOIN(2) 的OUTER即TBSCAN(2)，然后INNER 即 TBSCAN(4)，最后是连接断言本身即 NLJOIN(2)。
应用推荐