July 30, 2008 at 10:49 am
hi,
How important (in terms of performance) fill factor is in a
1- Clustered Index
a- Unique Values
b - Non Unique Values
2- Non Clustered Index
a- Uniqe values
b- Non Unique Values
Also what should be the value for fill factor for all of the above cases.
Thanks,
Usman
July 30, 2008 at 1:07 pm
Very important in all cases.
It should be somewhere between 1 and 100.
In other words, it depends on your data.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 2, 2008 at 12:45 pm
are you experiencing page splits on your server?
SQL server default is 0 which means the same as 100% (you can alos specify when rebuilding an index which overrides the default), Set the factor too low and your database size will grow and have to perform more reads (as there are more pages).
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply