Clarity Configuration Automation

Tech Tip: How to ReIndex CCA Database 

07-09-2015 12:29 PM

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

Statistics
0 Favorited
2 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.