Certain operations taking too long? Try re-indexing all the tables in the database For SQL Server:: USE ccadb GO EXEC sp MSforeachtable @command1 = "print '?' DBCC DBREINDEX ('?', ' ', 80)" GO EXEC sp updatestats GO For Oracle: select 'ALTER INDEX ...