Tech Tip: How to ReIndex CCA Database

Document created by A_H Employee on Jul 9, 2015
Version 1Show Document
  • View in full screen mode

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_updatestats
GO

 

ORACLE:

select 'ALTER INDEX '||INDEX_NAME||' REBUILD'

from cca_indexes
where owner=upper('cca');

 

 

Note, this may take hours to completed based on your environment and the data within your CCA Database

Attachments

    Outcomes