SET [NO]HASHAGG and SET [NO]HASHJOIN is added to the SET statement. Also, WITH [NO]HASHAGG and WITH [NO]HASHJOIN is added to the SELECT statement WITH clause.

The SET [NO]HASH statement and WITH [NO]HASH clause, which used to apply to hash joins only now apply to both hash aggregation and hash joins.

This enhancement lets you control whether the query optimizer should use hash aggregation, hash joins, or both.