Nested loops join

From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽

A nested loops join is a join optimization method where every row in the driving table (or outer table) is compared to the inner table.

Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #