Search

1 to 2 of 2
Sort by

Library Entry
CCA Performance: ReIndex CCA Database

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 ...