Post reply

Rebuilt clustered index with new fill factor

  • September 17, 2010 at 10:08 am

    #229405

    Hi folks

    I Rebuilt clustered index with new fill factor 80%. The new filll factor is not reflected in avg_page_space_used_in_percent it shows 99% ?

    this is small table by the way only 250 pages, so this is not a big deal I know the rule of thumb is 1000 pages or more an index is big enough to worry about in some folks eyes..others say less. needles to say I was just curious.

    THANKS

  • September 17, 2010 at 11:44 am

    #1223232

    If I right click on the index it says 80.41 % for page fullness but under

    sys.dm_db_index_physical_stats I get 98% for avg page space used? I thought they would be the same.....which tells me I must be misunderstanding something?

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

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