Post reply

clustered index internals

  • March 23, 2012 at 5:48 am

    #270712

    From SQLServer 2008 Implementation and Maintenance Book published by Microsoft :

    "Clustered index provide a sort order for storage of data with in a table. However clustered index doesnot provide a physical sort order. Clustered index doesnot physically store data in the disk, instead clustered index index ensures that the page chain of the index is sorted logically. A SQL Server traverses the clustered index page chain each row of data is read in clustering key order"

    Does this mean there will not be any physical sorting of data in the storage (disk) for any inserts / deletes. Just curious 😎

    Thanks

    GK

  • March 23, 2012 at 6:30 am

    #1463308

    Never has been. Indexes enforce the logical order, not the physical. An index build or rebuild will try to put the pages down in physical order matching logical, but that's it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply