When we checked the stats for one of our databases we found that some of
our big indexes were showing as having more than 3 leaf buckets - the
suggestion at the time was to increase the page size to reduce the no of
leaf buckets and this did improve performance.

HTH, Ian

Nico Callewaert wrote:

> And a page size of 4096, is that ok ?
>