The new BT_PREFETCH_MAX_MISS option controls the way IQ determines whether to continue prefetching B-Tree pages for a given query. This option can be used to improve performance of queries using HG indexes that run more slowly than expected. For more information, see “BT_PREFETCH_MAX_MISS option” in the Sybase IQ Reference Manual.
