Post reply

Index Fill factor

  • August 20, 2009 at 2:06 pm

    #134886

    Hi,

    What should be the ideal fill factor for an index?

    What is should be the value for development i.e a table in OLTP

    and OLAP database?

    In which database OLTP or OLAP the fill factor will more and on what basis this fill factor depends upon?

    Waiting for suggestion(s)

  • August 21, 2009 at 9:24 am

    #1042914

    There is not a thing called as correct fill factor, that depends upon table to table, just start with 80 and test it if this work for you and adjust the fill factor as per your needs 🙂

  • August 21, 2009 at 9:43 am

    #1042940

    For OLTP: make sure you take into account the size of a row in the table (if the row has Varchar columns, probably use the Avg actual size) when choosing. If your table's rows are really short, you might be able to get away with less free space per page.

    If I remember right, even if you choose a really low fill factor, SQL will attempt to leave room for 1 row on the page.

    I don't have enough experience with OLAP to have an opinion...

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

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