How to decide on Fill Factor value

• ishwarjindal

  SSC Journeyman

  Points: 97

  More actions

  November 3, 2003 at 8:04 am

  #82531

  scenario is that

  i have a primary key identity column (1,1) and i know that data from this table will never be deleted.

  Should we create the index on this column with Fillfactor 100 or not.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 3, 2003 at 8:12 am

  #480656

  I suggest you first take a look at BOL fill factor -> fill factor

  And maybe this one will also help http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_2ri0.asp

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 3, 2003 at 8:16 am

  #480659

  Sorry, I had multiple instances running and lost track

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  November 4, 2003 at 3:06 am

  #480744

  The fillfactor is only taken into account when the index is created or recreated. After it is not maintained.

  If you are shure you will never upgrade or change the the index keys it is reasonable to considere the fillfactor=100.

  But if you are creating a clustered index be shure your data won't change neither because the the data is stored with the index itself

  Bye

  Gabor

  
  
  Bye
  Gabor