|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, December 29, 2009 7:12 PM
Points: 8,
Visits: 34
|
|
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!
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, December 29, 2009 7:12 PM
Points: 8,
Visits: 34
|
|
| 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.
|
|
|
|
|
SSChasing Mays
Group: General Forum Members
Last Login: 2 days ago @ 7:24 AM
Points: 601,
Visits: 473
|
|
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" ?
|
|
|
|
