There are many variants of the traditional nested-loop join. If the index is built as part of the query plan and subsequently dropped, it is called

A. Naive nested-loop join
B. Index nested-loop join
C. Temporary index nested-loop join
D. None of these

Ans:  C

0 comments: