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.
Remarks
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
Technical Support.