If you experience some slowness in CCA reporting or operations that require database intensive operations, please try to reindex your CCA database .
EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?', ' ', 80)"
select 'ALTER INDEX '||INDEX_NAME||' REBUILD'
Note, this may take hours to completed based on your environment and the data within your CCA Database