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