Home Forums Article Discussions Article Discussions by Author Discuss content posted by Hugo Kornelis Clustered indexes RE: Clustered indexes

  • May 7, 2010 at 9:22 am

    #1164189

    Hugo,

    Thanks for the response. I stand corrected and will recreate my clustered indexes more frequently 😛

    Thanks,

    Joe

    Hugo Kornelis (5/7/2010)

    dunnjoe (5/7/2010)

    I believe this explanation is incorrect for the way the question was asked. Your question asked if the rows were physically or logically ordered, not if the pages were physically or logically ordered. All the rows are indeed physically ordered on their pages based on the clustered index.

    Thanks for the feedback, dunnjoe!

    However, the question was about the ordering of rows in a table, not rows on a page, so I don't think that part of the question was phrased incorrect.

    And even if it had been about rows on a page - not even those are physically ordered; see my reply to Jan, a few posts back (near the top of this page).