Controls the maximum percentage of a user’s temp memory that a hash object can pin.
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. 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.