Home Forums SQL Server 2008 SQL Server 2008 Administration Difference between Data Fragmentation & Index Fragmentation RE: Difference between Data Fragmentation & Index Fragmentation

  • January 3, 2013 at 6:04 am

    #1573276

    Shadab Shah (1/3/2013)

    Hi all,

    I am a newbie in SQL Server. I was exploring fragmentation topic. i came across two term which were most confusing to me and i tried to find out are those 2 term different or same.

    This 2 terms are 'Index Fragmentation' & 'Data Fragmentation'. There name are sufficient to tell me that they mean fragmentation while indexing & storing data. Does other than this they mean something.

    I believe both means the same. Fragmentation occurs when loss of allocation order of data pages happens. So, in terms of index fragmentation, it means when the loss of allocation order of data pages at the leaf node level of the index.

    I would wait for experts opinion on this. What I mentioned above is my understanding.

    SueTons.

    Regards,
    SQLisAwe5oMe.