Specifies the amount of memory used for prefetching.
Scope
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.
Description
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.