I found out that there is a lot of fragmentation on tables & indexes in
a database on the current SQL2000 server.
BOL recommends to drop/recreate cluster indexes.
It doesn't say anything about non-cluster indexes. Do I have to worry
about them? Do I only defrag cluster indexes, not non-cluster?