Maximum percentage of a user's temp memory that a hash object can pin.
0-100
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.
20
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 this number should be reduced to 10% for sites that run a lot of very complex queries or increased to 50% in sites with simple queries that need a single large hash object to run, such as a large IN subquery.
This option is primarily for use by Sybase Technical Support. If you change the value of HASH_PINNABLE_CACHE_PERCENT, do so with extreme caution; first analyze the effect on a wide variety of queries.
