开发者

On a Heap Table, what does a non-clustered index use as a pointer to a row?

Pick your version of SQL Server... if it has changed between version please spec开发者_运维百科ify if you know.

Build a table Add a non-clustered index on 1 or more columns. If I could dump a leaf block, what would I find as the pointer to the row in the table with the data?


It uses a row id, which is basically a physical address of the row in the database: on Page X at Slot Y. If the row ever moves, then a Forwarding record is left in place so that the non-clustered index reference is kept valid. See Forwarding and forwarded records, and the back-pointer size.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜