nested loop的意思

nested loop中文翻譯：

[計]嵌套循環

相似詞語短語

belt loop───束帶圈，袢帶

Henle's loop───享勒襻

Henles loops───亨氏環

haunted look───鬧鬼的樣子

congested road───擁擠的道路

converted loft───轉換閣樓

Lippes loop───利普斯節育環

belt loops───束帶圈，袢帶

bushed lot───灌木叢地段

雙語使用場景

Nested loop join (NLJOIN) with sort composite.───使用復合排序的嵌套循環聯接(NLJOIN)。

Example 5: INLIST to Nested Loop Join (query rewrite).───例子5：INLIST改為嵌套循環連接(查詢重寫)。

The only interesting thing now is a nested loop.───唯一有趣的是現在是一個嵌套循環。

The Continue keyword can be used in a nested loop to skip to the next iteration of an outer loop.───可以在嵌套循環中使用Continue關鍵字以跳到外層循環的下一次迭代

The result of that join operation then becomes the first input to the second join operation (also a nested loop join).───該聯接操作的結果就成為第一個聯接操作輸入到第二個聯接操作（也是一個嵌套循環聯接）。

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.───然而，合并掃描聯接的好處是不必反復地掃描內部表因為其為嵌套循環聯接工作。

This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.───這種類型的訪問路徑被稱為使用復合排序的嵌套循環聯接（NLJOIN）。

As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.───如前所述，按順序的輸入對于合并掃描聯接是必不可少的，但其無需嵌套循環聯接。

Adjusted the wording of the introduction and added the forcing of a nested loop join.───調整了簡介的措辭并添加了強制使用嵌套循環聯接。

英語使用場景

For more information about nested loop joins, refer to the appropriate information center link in the Resources section for your DB2 platform.

This is a lot faster than a nested loop join of two table scans without any index usage.

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.

The nested loop join method is used to join the remote query result from each warehouse and the XML composite view result.

This registry variable causes the optimizer to favor nested loop joins to join the list of values, using the table that contributes the IN list as the inner table in the join.

The only interesting thing now is a nested loop.

For each row, the nested loop join (NLJOIN) operator passes a pointer to the corresponding XML document to the XSCAN operator.

Figure 4 shows a plan using the nested loop join operations at the federated server to evaluate this query.

So when compared to a nested loop join, the merge scan join may incur the cost for sorting the inputs.