• Normally you reorganise the index if the fragmentation is less than 30% (I think MS recommends a 20% threshold) over that and you start to look at rebuilding the index as that will give you the better performance boost, as well as updating the stats.

    In terms of data pages the general consensus is its not always worth rebuilding if there are less than 1000 pages, but it can depend.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices