Based on your other post about dropping the clustered index, I would guess you could have also used DBCC INDEXDEFRAG to defragment your indexes.

You can use DBCC SHOWCONTIG to show information about the table and index fragmentation and sql help has some pretty good tips on what to look for.


>That was done... and there was no change. This is a real weird one. Any other thoughts?
>
>>Try update statistics your_table_name.