SET HASH allows the query optimizer to consider using hash aggregation (see page [No]Hashagg) and hash joins (see page [No]Hashjoin).

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

SET HASH is the default.