Specifies the percent of memory used for prefetching.
0 to 100
Can be set only for the PUBLIC group. DBA authority is required to set the option. You must shut down and restart the database server for the change to take effect.
40
This option is an alternative to the PREFETCH_BUFFER_LIMIT option, as it specifies the percentage of cache available for use in prefetching.
Do not set this option unless advised to do so by Sybase Technical Support.
