time ago in another post I showed how to re-index an entire database.
Well, before you do that you can study the state of the database and display the statistics with the command: exec
sp_msforeachtable 'dbcc SHOWCONTIG ("?")'
One of the important parameters is the "Scan Density", plus the value is low unless the indexes will be performing.
