![SQL_FLAGGER_ERROR_LEVEL option [TSQL]](arrow-right.gif){kind=icon}
Specifies the maximum percentage of currently available buffers a sort object will try to 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
For very large sorts a larger value may help reduce the number of merge phases required by the sort. A larger number, however, may impact other users’ sorts and hashes running on the system. If you change this option, you must experiment to find the best value to increase performance, as choosing the wrong value may decrease performance. Sybase recommends using 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.
