November 17, 2009 at 7:28 pm
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!
November 17, 2009 at 7:52 pm
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.
November 17, 2009 at 10:06 pm
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