ASA Database Administration Guide
  Database Options
    Alphabetical list of options

MAX_WORK_TABLE_HASH_SIZE option [database]

Function 

Specify the maximum hash size used during query optimization for internal temporary tables.

Allowed values 

Integer, from 2 to 64 inclusive.

Scope 

Can be set for the PUBLIC group only. Takes effect immediately. DBA permissions are required to set this option.

Default 

20

See also 

Use of work tables in query processing.

Description 

In general, you should not need to use this option as the query optimizer allocates hash sizes for the internal temporary tables based on the data distribution within the table. The option allows you to override the optimizer behavior to either increase the maximum hash size it can use beyond 20, or to restrict it further. This option is deprecated.