Home Forums Article Discussions Article Discussions by Author Discuss content posted by alok Storage Size RE: Storage Size

  • April 11, 2008 at 1:08 am

    #801313

    imrandn (4/10/2008)

    hi SSCommitted,

    I was confussed with Index key for indexes as your index key also take space in the row and effects of total size of the row (I think the index key can be maximum 900).

    Thanks

    Hi imrandn,

    The index key is the PK_ID column, which is already counted in the space calculations. It's not stored another time as part of the index structure. (At least not in the data pages),

    The 900 byte limit is (I guess) related to the effectiveness of the B-tree structure WRT root and intermediate pages. These pages only hold the value of indexed columns and a pointer.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/