Rebuild index and fill factor

Answers

• DenSter Member Posts: 8,307

  2015-11-05 Answer ✓

  It should use the default value that is set at the server level

  Daniel Rimmelzwaan
  RIS Plus, LLC

  5
• Phenno Member Posts: 630

  2015-11-06

  Is there a way to check it?
  
  I'm asking this because alter index help says that the default value for fillindex option is 0. https://msdn.microsoft.com/en-us/library/ms188388.aspx

  0
• Phenno Member Posts: 630

  2015-11-06

  Ok, now I see that I was not precise in question. I was asking for ALTER INDEX REBUILD command, not DBCC DBREINDEX. It seems that DBREINDEX uses last set fillfactor from sys.indexes (https://msdn.microsoft.com/en-us/library/ms181671.aspx), but ALTER INDEX uses 0.
  

  0
• Phenno Member Posts: 630

  2015-11-06

  Interesting thing is that in Olla's rebuild script manual it says that it will use fillfactor from sys.indexes althought in a script he uses ALTER INDEX where I cannot see any reference to sys.indexes prior to execution...
  
  I checked on test database and indeed ALTER INDEX will use fillfactor from sys.indexes if not specified.

  0