• The answer is it depends. Fill factor of 100 is fine for a clustered index on an incrementing value if your adding data and not updating or deleting. A fill factor of 90 is usually the default I use. If a lot of updates will change the logical order then a lower fill factor may be better.