Is it okay to have a fill factor of 100 on the clustered index that is on an ID column?

10 votes

2 answers

5457 views

sql-server best-practices clustered-index fill-factor

                          So I have a table with a clustered index on an ID column (which is an auto-increment column) in SQL Server.

Is it okay to have a fill factor of 100 on this since the data will always get written with the next latest ID? Would it matter if the other columns on this table get updated a lot for the existing IDs?

Also, how would deletes impact the fragmentation of the table?

Asked by croxfade (186 rep)

Oct 11, 2016, 03:56 PM
Last activity: Oct 12, 2016, 03:10 PM

Is it okay to have a fill factor of 100 on the clustered index that is on an ID column?

Related Questions