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

Default

10

Scope

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

Description

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