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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2004-11-09 : 06:20:28
|
| will the select queries be quicker if the fill factor is set to a low figure?Thanks |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2004-11-09 : 06:51:24
|
| HiIt depends whether the database is a write intensive or read intensive. If it is a write intensive database then it is good practice to keep the fill factor low, But if it is read intensive then it should be heigh. Let me explain why?Fill factor means the amount of data which will be stored in the pages. Lets say if the fill factor is 80% then 80 percent of the page will be filled and the rest will be empty. This is to avoid the page splits. Page splits make the selection slower as the indexes get fragmented. To the best of my knowledge if u increase the fillfactor, then selection will be faster, as there will not be much movement of the head to read data from the disk. RgdsSachin |
 |
|
|
|
|
|
fill factor