Home Forums SQL Server 2005 Administering After Index Rebuild, the fragmentation rate is still very high RE: After Index Rebuild, the fragmentation rate is still very high

  • Joe is correct...

    Additionally, if the table is HEAP (no cluster index) then ur fragmentation not remove.

    The above statements is true put the cluster index and drop it then ur fragmentation removed.

    (As per MS a table must have cluster index)

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/