Sunday 15 January 2012

sql server - Does database modify the actual data page when we create a clustered index? -



sql server - Does database modify the actual data page when we create a clustered index? -

i not dba guy, so, might pretty simple question, please help me clarify doubt.

we using sql server 2012 in our environment.

i reading info pages. came know that, if records in info page need order, info in slot array (pointer of actual data) gets re-ordered, not actual data. can understand this. if create clustered index in heap table, rearranging slot array not enough, in case, database modify actual info of info page?

let's first row should page:1, sec row should page:5 , 3rd row should page:2. db create new page these records , maintain slot array ordering?

i hope question clear. if need farther information, please allow me know.

there's short reply 1 : yes

sql-server clustered-index

No comments:

Post a Comment