Your deployment of CCS, stores a large amount of data in the databases. Over a period of time, heavy use of the product causes index fragmentation in the CCS databases. This affects the performance of the tasks that are dependent on the databases. It is necessary to plan and perform database maintenance tasks, to optimize the performance of the databases.
CCS databases also include detailed evidence data of the Standards module and external data providers. This data is stored in separate filegroups. You can perform certain tasks on the database to optimize the database performance and storage management, such as moving the filegroups to different disks or compressing the filegroups.