HASH_PINNABLE_CACHE_PERCENT option

Function

Maximum percentage of a user’s temp memory that a hash object can pin.

Allowed values

0 – 100

Default

20

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Description

HASH_PINNABLE_CACHE_PERCENT controls the percentage of a user’s temp memory allocation that any one hash object can pin in memory. It defaults to 20%, but reduce this number to 10% for sites that run complex queries, or increase to 50% for sites with simple queries that need a single large hash object to run, such as a large IN subquery.

The HASH_PINNABLE_CACHE_PERCENToption is for use by primarily Sybase Technical Support. If you change the value of it, do so with extreme caution; first analyze the effect on a wide variety of queries.

See also

“BIT_VECTOR_PINNABLE_CACHE_PERCENT option”.

“SORT_PINNABLE_CACHE_PERCENT option”.