PREFETCH_GARRAY_PERCENT option

Function

Specifies the percent of prefetch resources designated for inserts to HG indexes.

Allowed values

0 – 100

Default

60

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.

Description

As with PREFETCH_SORT_PERCENT, this option designates a percentage of prefetch resources for use when inserting into an HG index.

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