Nested loop join (NLJOIN) with sort composite

使用复合排序的嵌套循环联接 (NLJOIN)

The only interesting thing now is a nested loop.

唯一有趣的是现在是一个嵌套循环。

It contains a nested loop that calls exp(), cos(), and sin(), followed by a loop that calls sin() and sqrt().

它包含了一个嵌套的循环，该循环会调用exp()、cos()以及sin()，接下来是一个调用sin()和sqrt() 的循环。

This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.

这种类型的访问路径被称为使用复合排序的嵌套循环联接 (NLJOIN)。

The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.

最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。

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 ）。

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)。