From technet I got the impression, that I either have to explicitly set the wanted fillfactor or when I do not specify it, the default fillfactor 0 is choosen.

For tables I know to get rows added fillfactor 0 isn't a good choice. Is there a way to rebuild an index, so that the last explicitly index is used ?

BTW: I think that that should be the default setting.

1 Answer 1


When a new index is built is uses the default fill factor by default, unless a different fillfactor is specified.

When an index is rebuild it will use the same fill factor that was specified when the index was build or last rebuilt unless a different fillfactor is specified.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.