Set hash allows the query optimizer to consider using hash aggregation and hash joins.

Set nohash stops the query optimizer from considering the use of hash aggregation and hash joins.

Set hash is the default.