![PRESERVE_SOURCE_FORMAT option [database]](arrow-right.gif){kind=icon}
Specifies the percent of prefetch resources designated for sorting objects.
0 – 100
50
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.
PREFETCH_SORT_PERCENT designates a percentage of prefetch resources for use by a single sort object. Increasing this value can improve the single-user performance of inserts and deletes, but may have detrimental effects on multiuser operations.
Do not set this option unless advised to do so by Sybase Technical Support.
