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-08 : 06:15:06
|
| I have changed the fill factor of the clustered index to 40 and the non-clustered as the default fill factor.The performance is better the lower I set the fill factor for the clustered index.So may be I should set it to 10 to get a better performance for select queries?Thanks |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-08 : 07:13:56
|
| As long as you don't mind using the extra disk space. I assume you're doing a great deal of insert activity and were getting a lot of page splits with the higher fillfactor. |
 |
|
|
|
|
|
fill factor