Post reply

Does fill factor affect performance of insert statement execution?

  • September 26, 2012 at 11:17 am

    #264916

    If I have 85 for fill factor will my inserts run faster vs. inserting with default fill factor of 0/100? Why?

  • September 26, 2012 at 11:32 am

    #1542554

    Maybe. If an insert has to go on a page and there's no space, the page splits and that's an expensive operation, the 85% fill factor ensures there will be some free space after the rebuild

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply