Maximum percentage of a user’s temp memory that a hash object can pin.
0 – 100
20
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.
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.
