index rebuild/ with(online=on)

• webc

  SSC-Addicted

  Points: 420

  More actions

  November 17, 2009 at 7:28 pm

  #206593

  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!

• webc

  SSC-Addicted

  Points: 420

  More actions

  November 17, 2009 at 7:52 pm

  #1080651

  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.

• Henrico Bekker

  One Orange Chip

  Points: 27652

  More actions

  November 17, 2009 at 10:06 pm

  #1080679

  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