这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
连接计划指示,强制优化器使用指定的连接方法来连接查询中的表,要么是嵌套循环连接、分类合并连接,要么是动态哈希连接。
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.
以上示例展示了如何使用连续扫描和索引来进行数据检索,以及如何使用嵌套循环连接方法来连接所有表。
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.
而且,嵌套循环联接方法用于联接源表与目标表。
Also, the nested loop join method is used to join the source and target tables.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
The most commonly used join methods are nested-loop join, sort merge join and dynamic hash join.
在之前的部分您已经了解了一种类型的访问方法,即索引扫描(IXSCAN),和一种类型的联接方法,即嵌套循环联接(NLJOIN)。
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).
执行带有循环(特别是嵌套循环)的方法可能需要耗费很多时间。
Methods with loops, and particularly nested loops, can be time-consuming to execute.
给出了将具有变相关的嵌套循环映射到具有分布式存储的多处理机上的两种方法。
Two new methods for partitioning and mapping nested loops with non-constant dependencies into distributed memory multiprocessors are presented.
这个方法由两个嵌套的循环组成:第一个循环遍历所有注册的类型。
This method consists of two nested loops: the first loop iterate through all the registered types.
在并行编译中,循环变换是开发程序并行度的主要方法,但存在复杂控制流的非紧密嵌套循环往往无法得到有效的并行化。
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.
在并行编译中,循环变换是开发程序并行度的主要方法,但存在复杂控制流的非紧密嵌套循环往往无法得到有效的并行化。
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.
应用推荐