例子5:INLIST改为嵌套循环连接(查询重写)。
这比不使用任何索引的两个表扫描的嵌套循环连接要快得多。
This is a lot faster than a nested loop join of two table scans without any index usage.
如果满足下列条件,优化器将选择嵌套循环连接。
图4展示了一个在联邦服务器使用嵌套循环连接操作符来计算这个查询的计划。
Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.
最常用的连接方法就是嵌套循环连接、分类合并连接和动态哈希连接。
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.
其中有一个insert(步骤5)与索引扫描(步骤7)之间的嵌套循环连接(NLJOIN,步骤4 )。
There is a nested loop join (NLJOIN, step 4) of the insert (step 5) to an index scan (IXSCAN, step 7).
连接计划指示,强制优化器使用指定的连接方法来连接查询中的表,要么是嵌套循环连接、分类合并连接,要么是动态哈希连接。
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.
QB 1中三个表用嵌套循环(NLJ)连接。
这里使用了嵌套的循环连接方法来连接来自每个仓库的远程查询结果和xml合成视图结果。
The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.
提出了一种基于缓冲的高速缓存参数无关的嵌套循环并行连接算法。
A buffering based cache-oblivious nest-loop parallel join algorithm is proposed.
提出了一种基于缓冲的高速缓存参数无关的嵌套循环并行连接算法。
A buffering based cache-oblivious nest-loop parallel join algorithm is proposed.
应用推荐