Home Forums SQL Server 2005 Administering index RE: index

  • April 25, 2010 at 11:52 pm

    #1157456

    mvm_mca07 (4/23/2010)

    how the fragment and defragment was done in index

    Insert/Update/Deletes cause index fragmentation.

    Alter index rebuild/reorganize is used to defragment index.