Posted - 05/17/2013 : 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)
Now I run Two Command
1)Delete the Record 3rd position
Delete From tbl where Col=103
2)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 of
the B-Tree or in Blank space.