![SQL_FLAGGER_ERROR_LEVEL option [TSQL]](arrow-right.gif){kind=icon}
Specifies the maximum percentage of currently available buffers a sort object tries to 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.
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.
