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.

This option effectively controls the amount of time the optimizer spends searching for the best index to use for a range predicate. Setting this option higher may cause a query to spend more time in the optimizer, but as a result may choose a better index to resolve a range predicate.