SORT_PINNABLE_CACHE_PERCENT option

Function

Specifies the maximum percentage of currently available buffers a sort object tries to 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

For very large sorts, a larger value might help reduce the number of merge phases required by the sort. A larger number, however, might impact other users’ sorts and hashes running on the system. If you change this option, experiment to find the best value to increase performance, as choosing the wrong value might decrease performance. Sybase recommends that you use the default value for SORT_PINNABLE_CACHE_PERCENT.

This option is primarily for use by Sybase Technical Support. If you change the value of SORT_PINNABLE_CACHE_PERCENT, do so with extreme caution.