5 responses

  1. Tim
    2013-08-26

    A bit late but great post Wayne! I was researching how clustered indexes affected the physical ordering of the pages themselves and came across your page, since this is a common question asked of SQL Developers I thought I’d dig deeper. You’ve discussed how the row ordering within a page does not always following logical ordering, how about the pages themselves?

    Reply

  2. Wayne Sheffield
    2013-08-26

    Hi Tim, thanks for asking. When this page becomes full and a new record is added (assuming it to be at the end of the range), a new page will become allocated for the new record, and the new record added to the new page. This new page will, for this index, be the next logical page. However, it may not be the next physical page in the file, creating fragmentation in the index.

    Does this answer your question?

    Reply

  3. Tim
    2013-12-16

    Yes it does, thanks Wayne.

    Reply

  4. Frank Garcia
    2021-12-01

    great article, im going to kick around fill factor for a bit to see what happens.

    Reply

Leave a Reply to let me know how you liked this post

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to top
mobile desktop