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