HG_SEARCH_RANGE option

Function

Specifies the maximum number of Btree pages used in evaluating a range predicate in the HG index.

Allowed values

Integer

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect immediately.

Default

10

Description

The default setting of this option is appropriate for most queries.