SET HASH allows the query optimizer to consider using hash aggregation (see [NO]HASHAGG) and hash joins (see [NO]HASHJOIN).

SET NOHASH stops the query optimizer from considering the use of hash aggregation and hash joins.

SET HASH is the default.