3、 嵌套循环(Nested Loop):在最少两个结果集中,使用嵌套循环会比较有效,这两个结果集中,作为外部表的集合要小,而内部循环结果集具有有效的索引。
基于1014个网页-相关网页
1) NESTED LOOP(嵌套循环连接):当有高选择性索引或进行限制性搜索时,并且对于被连接的数据子集较小的情况,nested loop连接是个较好的选择。
基于38个网页-相关网页
Nested Loop Join 嵌套循环连接 ; 嵌套循环联结 ; 嵌套循环联接
Nested Loop Joins 嵌套循环连接
non-nested loop mode [计] 非嵌套循环方式
nested loop structure 巢套回路结构 ; [计] 嵌套循环结构
nested loop mode [计] 嵌套循环方式
nested loop method 巢状回路法
nested loop nesting 巢套循环
index nested-loop join 索引循环嵌套连接
block nested loop join 块嵌套循环连接
We also research two kinds of commonly used techniques-software pipelining and loop unrolling, which turns the loop level, especially the nested loop level parallelism into the instruction level parallelism.
本文还研究了将循环(尤其是多重循环)级并行转化为指令级并行的两种常用技术:循环展开与软件流水。
参考来源 - 基于X流处理器的循环实现及优化·2,447,543篇论文数据,部分数据来源于NoteExpress
The 3 tables in QB1 are joined with nested loop join (NLJ).
QB 1中三个表用嵌套循环(NLJ)连接。
Also, the nested loop join method is used to join the source and target tables.
而且,嵌套循环联接方法用于联接源表与目标表。
Here's what happens at execution time for the first leg of the nested loop join.
以下是在执行嵌套循环联接的第一步时将发生的操作。
Then the next thing in the loop, we're going to enter a nested loop and say for every college in the list e, we're going to print the name of the college.
循环中的第二件事,是进入一个嵌套循环,这个嵌套循环将数组中的,大学名字显示出来。
The only interesting thing now is a nested loop.
唯一有趣的是现在是一个嵌套循环。
应用推荐