Specifies the amount of memory used for prefetching.
Integer
0
Can be set only for the PUBLIC group. DBA authority is required to set the option. Shut down and restart the database server to have the change take effect.
PREFETCH_BUFFER_LIMIT defines the number of cache pages available to Sybase IQ for use in prefetching (the read-ahead of database pages).
Do not set this option unless advised to do so by Sybase Technical Support.
