HASH (JOIN Option)
HASH causes the optimizer to choose a hash algorithm, if possible, for the join. If HASH is not specified, the optimizer chooses the best algorithm for the join.
Operator
JOIN
Syntax
hash
Example
SELECT column1 FROM table1 INNER {OPTION HASH} JOIN table2
ON table1.id = table2.id