HASH_PINNABLE_CACHE_PERCENT Option

Controls the 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. The default is 20%, but you should reduce this number to 10% if you are running complex queries, or increase this number to 50% if you have simple queries that need a single large hash object to run, such as a large IN subquery.

HASH_PINNABLE_CACHE_PERCENT 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.

Related reference
BIT_VECTOR_PINNABLE_CACHE_PERCENT Option
SORT_PINNABLE_CACHE_PERCENT Option