Home Forums SQL Server 2008 SQL Server 2008 Administration Do people rebuild indexes if non-leaf levels exceed fragmentation threshold? RE: Do people rebuild indexes if non-leaf levels exceed fragmentation threshold?

  • November 1, 2012 at 10:56 am

    #1555109

    If the leaf level fragmentaion is low, it would probably be much faster to do an index reorganize(defrag), instead of a rebuild.

    Or just leave it alone.