Home Forums SQL Server 2005 Administering cluster index and non-clustered index RE: cluster index and non-clustered index

  • January 21, 2013 at 7:16 am

    #1579241

    Scott Rankin (1/21/2013)

    This is what a clustered index does. If physically orders the data within the table.

    Logical order. Not physical. The index may be physically ordered by the clustered index, but it's not enforced.

    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