GARRAY_INSERT_PREFETCH_SIZE option

Function

Specifies number of pages used for prefetch.

Allowed values

0 to 100

Scope

DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.

Default

3

Description

This option defines the number of database pages read ahead during an insert to a column that has an HG index.

Do not set this option unless advised to do so by Sybase Technical Support.