Discussion Board

Naive nested-loop join In the simplest case, the search scans an entire table or index; this is called a naive nested loop join. If the search exploits an index, it is called an index nested loops join. If the index is built as part of the query plan, it is called a temporary index nested loops join. All these variants are considered by the query optimizer. The nested loops join, also called nested iteration, uses one join input as the outer input table and one as the inner input table. Prajakta Pandit 03-21-2017 02:11 AM

Write your comments

*

* Email must be in the form someone@domain.com

*

*