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