唯一有趣的是现在是一个嵌套循环。
QB 1中三个表用嵌套循环(NLJ)连接。
而且，嵌套循环联接方法用于联接源表与目标表。
Also, the nested loop join method is used to join the source and target tables.
使用复合排序的嵌套循环联接(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.
例子5：INLIST改为嵌套循环连接(查询重写)。
在数组的嵌套循环——CUDA实现二维累积？
Cumulative sum in two dimensions on array in nested loop — CUDA implementation?
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
与嵌套循环联接相反，索引不再是非常重要的了。
Contrarily to the nested loop join, indexes are no longer so important.
如果满足下列条件，优化器将选择嵌套循环连接。
执行带有循环(特别是嵌套循环)的方法可能需要耗费很多时间。
Methods with loops, and particularly nested loops, can be time-consuming to execute.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
因此，当与嵌套循环联接比较时，合并扫描联接可能对于排序输入产生成本。
So when compared to a nested loop join, the merge scan join may incur the cost for sorting the inputs.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
提出了一种基于缓冲的高速缓存参数无关的嵌套循环并行连接算法。
A buffering based cache-oblivious nest-loop parallel join algorithm is proposed.
然而，合并扫描联接的好处是不必反复地扫描内部表因为其为嵌套循环联接工作。
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.
不要写双重嵌套循环只是为了炫耀你打破或者继续一个外循环的能力。
Don't write doubly nested loops just to show off your ability to break or continue an outer loop.
如前所述，按顺序的输入对于合并扫描联接是必不可少的，但其无需嵌套循环联接。
As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.
所以我看过很多的情况下，标签被用于循环爆发，尤其是双嵌套循环。
So I've seen a lot of cases where labels are being used in for loops to break out, especially with doubly nested loops.
因为嵌套循环联接的工作方式，所以每隔一个外部表记录执行第二步(共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).
在编写代码时应尽量避免嵌套循环，目前大多数代码都是使用了哈希表、简单链表和单循环。
Your code should (almost) never have multiple nested loops (a loop inside a loop inside a loop). Most of the code written today should use Hashtables, simple lists and singly nested loops.
给出了将具有变相关的嵌套循环映射到具有分布式存储的多处理机上的两种方法。
Two new methods for partitioning and mapping nested loops with non-constant dependencies into distributed memory multiprocessors are presented.
要了解嵌套循环联接的更多信息，请参考参考资料部分中针对您的DB 2平台的适当的信息中心链接。
For more information about nested loop joins, refer to the appropriate information center link in the Resources section for your DB2 platform.
以上示例展示了如何使用连续扫描和索引来进行数据检索，以及如何使用嵌套循环连接方法来连接所有表。
The above example shows that sequential scan and indexes are used to do the data retrieval, and the nested-loop join method is used to join all tables.
以我的经验来看，导致程序运行速度慢得罪魁祸首可能就是某个内部或嵌套循环，也可能是对第三方库函数的调用。
In my experience, it will usually be a particular inner or nested loop, or a call to some third party library methods, which is the main culprit for running the program slow.
一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
应用推荐