The 3 tables in QB1 are joined with nested loop join (NLJ).
QB 1中三个表用嵌套循环(NLJ)连接。
Here's what happens at execution time for the first leg of the nested loop join.
以下是在执行嵌套循环联接的第一步时将发生的操作。
This is a lot faster than a nested loop join of two table scans without any index usage.
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.
这种类型的访问路径被称为使用复合排序的嵌套循环联接(NLJOIN)。
Update bill_items (58 seconds); sequential scan of bill_items with a nested loop read of customer.
更新bill_items(58秒)；利用对customer的嵌套循环读取，来顺序扫描bill_items。
Contrarily to the nested loop join, indexes are no longer so important.
与嵌套循环联接相反，索引不再是非常重要的了。
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 realization of mapping a class of nested loop algorithms to linear systolic array is studied.
研究了一类多重循环算法的线性脉动阵列实现。
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的循环。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
For more information about nested loop joins, refer to the appropriate information center link in the Resources section for your DB2 platform.
要了解嵌套循环联接的更多信息，请参考参考资料部分中针对您的DB 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)。
Loop transformation is the basic way to maximization parallelism, but it doesn't work in the case of non - perfect nested loop with complicated control flow.
在并行编译中，循环变换是开发程序并行度的主要方法，但存在复杂控制流的非紧密嵌套循环往往无法得到有效的并行化。
If the query includes a join, the optimizer must determine the join plan (hash, sort merge, or nested loop), and the order in which tables are evaluated or joined.
如果该查询包含了连接，那么优化器就必须确定连接计划(hash、sortmerge或nested loop)，以及评估或连接表的次序。
Join plan directives that force optimizer to use the designated join method to join tables in the query, either nested loop join, sort merge join, or dynamic hash join.
连接计划指示，强制优化器使用指定的连接方法来连接查询中的表，要么是嵌套循环连接、分类合并连接，要么是动态哈希连接。
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.
以我的经验来看，导致程序运行速度慢得罪魁祸首可能就是某个内部或嵌套循环，也可能是对第三方库函数的调用。
This paper presents a framework for nested loop transformation, including dependence graph and offset-collection construction, analysis, transformation, and code generation.
本文研究了多媒体应用中常见嵌套循环的变换框架，包含了依赖关系的抽象和建立、分析和变换，以及最后变换代码的生成。
Nested loop join (NLJOIN) with sort composite.
使用复合排序的嵌套循环联接(NLJOIN)。
Example 5: INLIST to Nested Loop Join (query rewrite).
例子5：INLIST改为嵌套循环连接(查询重写)。
Join operators such as HASH, MERGE SCAN and (in some situations) NESTED LOOP can also benefit from asynchrony by simultaneously executing the inner and outer legs of the join operator.
MERGESCAN等连接操作符和(在某些情况下)NESTED LOOP也可以通过同时执行连接操作符的内分支和外分支而从异步中获益。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
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.
以上示例展示了如何使用连续扫描和索引来进行数据检索，以及如何使用嵌套循环连接方法来连接所有表。
However, if 0 is used in the predicate, a nested-loop join would be the optimal choice instead of merge join.
然而，如果断言中使用的值为0，那么内嵌循环联接可能是最优选择，而不是合并联接。
However, if 0 is used in the predicate, a nested-loop join would be the optimal choice instead of merge join.
然而，如果断言中使用的值为0，那么内嵌循环联接可能是最优选择，而不是合并联接。
应用推荐