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