index rebuild/ with(online=on)

  • when I rebuild index with (online =on ),the avg_fragmentation_in_percent decrease;but,when I rebuild index without use online Options,it can't affect,this confused me for many days ,who can tell me why?

    thanks!

  • may be related to the number of rows in the table ?when rows is small,it will not affect,but ,when rows is much ,it will affect.

  • run this first:

    =========

    DBCC SHOWCONTIG (table_name,index_name)

    GO

    =========

    note the fragmentation and scan density.....

    The execute;

    ==============

    DBCC DBREINDEX('table_name',index_name,54)

    ==============

    see any difference in logical frag and extent scan frag?

    is your scan density = 100% ?

    is your "Avg Pages per extend = 8" ?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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