Sample Header Ad - 728x90

Is there any benefit to specifying a fill factor when the table is empty?

0 votes
1 answer
341 views
When the table has lots of data, and I create a new index with fill factor (say 30), then sql server will leave space for new entries to be added into the data page. This will keep fragmentation low when new inserts are made. But if the table is empty, and I create an index, then what is the benefit of adding fill factor to the index?
Asked by variable (3590 rep)
Oct 6, 2021, 06:06 AM
Last activity: Oct 6, 2021, 09:37 AM