PREFETCH_BUFFER_LIMIT option

Function

Specifies the amount of memory used for prefetching.

Allowed values

Integer

Scope

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.

Default

0

Description

This option 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.