Post reply

Is RowID in a db page (when clustered index is not present) sorted?

  • April 16, 2008 at 11:35 am

    #184447

    Is it sorted?On what basis is the RowID sorted when there is a non clustered index present on the table?

    I am referring to the rowid (row pointer, not the identity) to which the non clustered indexes point at the leaf level of the tree when a clustered index is absent from a table.

  • April 17, 2008 at 1:49 am

    #803503

    If there's no cluster on the table, then the Rid (Row identifier) is the file ID, page number and slot index for the row.

    I don't think there's any definitive sorting on it at all.

    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

  • April 17, 2008 at 7:38 am

    #803706

    thanks.

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

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