Fill Factor

[Pauldohert]

Creating an index on a field in a table - I have read the help on fill factor which seems to say go with the default.

The default is 90%

Is this about right?

Thanks

 

[WayneRyan]

Paul,

If the data never changed, 100% would be ideal.

If you rarely add records, 90% would be fine.

In general, disk space is cheap, and as long as the table isn't
too volatile, the default is OK. If your server had thousands
of clients adding records (that needed indexes), then you'd
want a lower number like 50%.

Wayne

 

[Pauldohert]

Thanks - I'll leave it at 90%.