Post reply

The Downsides of Padding an Index?

  • March 31, 2009 at 2:26 am

    #207921

    Just finished reading "Who Cares about FillFactor?[/url]" and Mr. Jackson (great surname BTW 😉 mentioned that "y specifying the PAD_INDEX argument, you ensure that non-leaf level pages are also padded with the fillfactor setting." What are the downsides of padding an index, if any?

  • March 31, 2009 at 4:48 am

    #968952

    The index is bigger. That means more disk space will be needed to maintain. It's possible that it will have more levels because of the extra size which will add to the number of reads required to access it. But you have to balance that against the reduced number of splits and reorgs that will be caused.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • March 31, 2009 at 8:00 am

    #969133

    Thanks.

  • March 31, 2009 at 8:11 am

    #969146

    Thanks.

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

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