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