Specifies the amount of memory used for prefetching.
Scope
Option can be set at the database (PUBLIC) level
only.
Requires the SET ANY SYSTEM OPTION system
privilege to set this option. You must shut down
the database and restart it for the change to take
effect.
Description
PREFETCH_BUFFER_LIMIT defines the number of cache pages
available to SAP 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.