Search

1 to 2 of 2
Sort by

Library Entry
Tech Tip: How to ReIndex CCA Database

If you experience some slowness in CCA reporting or operations that require database intensive operations, please try to reindex your CCA database . SQL SERVER: USE cca GO EXEC sp MSforeachtable @command1 = "print '?' DBCC DBREINDEX ('?', ' ', 80)" GO EXEC sp...


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