Rebuild index and fill factor

Phenno
Phenno Member Posts: 630
in SQL Performance
Does T/SQL rebuild index command with no fillfactor set use fillfactor = 0 or fillfactor set on index or fillfactor set on server?

Best Answer

Answers

  • Phenno
    Phenno Member Posts: 630
    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
  • Phenno
    Phenno Member Posts: 630
    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.
  • Phenno
    Phenno Member Posts: 630
    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.

Categories