Restricts the size of the read-ahead buffer for the High Group B-Tree.
0 - 100. Setting to 0 disables B-Tree prefetch.
Can only be set for an individual user. Takes effect immediately.
10
B-Tree prefetch is activated by default for any sequential access to the High Group index such as INSERT, large DELETE, range predicates, and DBCC.
This option limits the size of the read-ahead buffer for B-Tree pages. Reducing prefetch size frees up buffers, but also degrades performance at some point. Increasing prefetch size may have marginal returns. This option should be used in conjunction with the options PREFETCH_GARRAY_PERCENT, GARRAY_INSERT_PREFETCH_SIZE, and GARRAY_RO_PREFETCH_SIZE for non-unique High Group indexes.
