Which variant of traditional nested-loop join is used when the entire table is scanned?

- Naive nested-loop join
- Index nested-loop join
- Temporary index nested-loop join
- None of these

CORRECT ANSWER : Naive nested-loop join

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


Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)