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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-08-07 : 03:36:12
|
| Hi,I heard that there will be a page-split whenever there is no space to accomdate the data in the index pages. Since i'm beginner to the topic index. I would like to know how page-splits happens w.r.t clustered and non-clustered.Assume that my (Clustered)index page look like this.2468When i try to insert a row '5' it moves half of the page to another page as the index page is full.But, what is the case in Non-clustered index whether there would be page-split because the non-clustered is basically a logical grouping of data so even when i insert the value '5' it moves to another page automatically without disturbing the existing data in the index page unlike clustered behaves (physical sorting - 6 and 8 are moved to another page).My question here is will there be a pagesplit in case of nonclustered index or the '5' is added to the new page without page splits. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-07 : 03:45:36
|
If depends on the fillfactor.Only when page is "full enough" a page split will occur.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
|
|
|
Page splits - Clustered vs Non-Clustered Index