Is concept of fill factor useful only when index is rebuilt?

3 votes

1 answer

197 views

                          Fill factor is concept that works only when creating a new index or when the index is rebuilt.

Subsequently there will be fragmentation due to inserts/updates which will create new pages (page split) without the fill factor.

Is it correct to say that the concept of fill factor is useful only when the index rebuilt?

Asked by variable (3590 rep)

Feb 10, 2022, 08:53 AM
Last activity: Feb 11, 2022, 01:55 PM

Is concept of fill factor useful only when index is rebuilt?

Related Questions