C. Features Introduced in Ingres 10S : Supportability Enhancements : SET HASHAGG and SET HASHJOIN
 
Share this page                  
SET HASHAGG and SET HASHJOIN
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.