NESTEDLOOP (JOIN Option)
NESTEDLOOP forces the optimizer to choose a nested-loop algorithm for the join. If you do not specify NESTEDLOOP, the optimizer chooses the best algorithm for the join.
Operator
JOIN
Syntax
nestedloop
Example
SELECT column1 FROM table1 INNER {OPTION nestedloop}
JOIN table2 ON table1.id = table2.id