SORTMERGE (JOIN Option)
SORTMERGE causes the optimizer to consider the sort-merge algorithm when choosing an algorithm for evaluating the join.
If SORTMERGE is set to FALSE, the sort-merge algorithm is excluded from consideration.
Operator
JOIN
Syntax
sortmerge[={"TRUE"|"FALSE"}]
Example
SELECT column1 FROM table1 INNER {OPTION sortmerge}
JOIN table2 ON table1.id = table2.id