Specifies the maximum number of Btree pages used in evaluating a range predicate in the HG index.
Integer
10
Can be set for an individual connection or the PUBLIC group. Takes effect immediately.
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.
