Controls the way IQ determines whether to continue prefetching B-Tree pages for a given query.
0 to 1000
Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.
2
For queries that use HG indexes, IQ prefetches B-Tree pages sequentially until it determines that prefetching is no longer useful. For some queries, it may turn off prefetching prematurely. Increasing the value of BT_PREFETCH_MAX_MISS makes it more likely that IQ will continue prefetching, but also may increase I/O unnecessarily.
If queries using HG indexes run more slowly than expected, try gradually increasing the value of this option. You may need to experiment with different settings to find the one that gives the best performance. For most queries, useful settings are in the range of 1 to 10.
