Clustered Indexes and Disk Storage

Question

Clustered Indexes and Disk Storage

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

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

Ray M SSC-Insane Points: 21093 More actions · Answer 1

Sql server does not move 1 row from each page it does what is called a page split. It will move roughly half the rows on the first page to another page leaving all other pages alone.

Please Read

Books online

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_9ak5.asp

vinod-228002 SSChasing Mays Points: 608 More actions · Answer 2

H!! Toad ,

In clustered index while inserting new record it will be put in order ..moreover if the page is full

the page splitting will occour and approx half data from the page is moved to the new page .Nothing else will occour .

regards,

Vinod S.R (DBA)

HTC Global Services

09840856202