Set the BT_PREFETCH_MAX_MISS option to control prefetch memory behavior.
The BT_PREFETCH_MAX_MISS option determines whether to continue prefetching pages for a given query. If queries using HG indexes run more slowly than expected, try gradually increasing the value of this option.