Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Dinesh.sharma2
Starting Member
2 Posts |
Posted - 2013-05-17 : 04:06:11
|
Hi Experts,I have one question Regrading Cluster Index on P.K Column.Suppose we have data in my table Col1(P.K Cluster Index) 101102103104105106Now I run Two Command1)Delete the Record 3rd position Delete From tbl where Col=1032)I insert the record like 10 value in Col. Insert into tbl values('109')First Question when we delete the record index rearrange the order of record Internally in B-Tree or Left the Blank space as it is.Second when we insert the record it always add at the end ofthe B-Tree or in Blank space. |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
|
|
|