1. The only interesting thing now is a nested loop.

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

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

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

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

6. 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.

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

8. 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.

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

10. New bit allocation module reduces the two nested loop structure to one single loop .

11. The realization of mapping a class of nested loop algorithms to linear systolic array is studied.

12. The result of that join operation then becomes the first input to the second join operation (also a nested loop join).

13. However,(Sentencedict) 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.

14. As previously stated, ordered input is essential to a merge scan join, but it is not required for nested loop joins.

15. This type of access path is referred to as a nested loop join (NLJOIN) with sort composite.

16. An NPSI would take advantage of lookaside on the index, for example, with a nested loop join in which the outer rows drive sequential access to the inner.

17. 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.

18. 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).

19. 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.