Posted by Jackie Brophy on 06/09/06 17:56

Do you have clustered indexes on the tables? They won't be defragmented
without them.

Jackie
<wackyphill@yahoo.com> wrote in message
news:1149873702.943298.103510@u72g2000cwu.googlegroups.com...
> Thanks for the info.
>
> After running UPDATE STATISTICS.
>
> I still received the same results from my 1st query (although I noticed
> it took signifigantly longer to run on the 1st attempt after running
> UPDATE STATISTICS.
>
> I still have an index at 83.3333333333333 fragmentation. It's wierd.
>

[Back to original message]