MEGA Administration : Administrator Guide : Managing Repositories : Optimizing Repository Access Performance : Performing regular maintenance tasks (RDBMS repository)
   
Performing regular maintenance tasks (RDBMS repository)
With RDBMS repositories you must include a regular maintenance plan. You (or your database administrator) should, for each repository (SystemDb repository included), perform the following maintenance tasks regularly (at least once a week):
• rebuild indexes
• update the statistics
• (optional) shrink the logs regarding the policies
• perform the stored procedures
*See "Deleting RDBMS Repository Temporary and History Data".
• SP_CLEAN_MEGA_DATABASE
• SP_CONSOLIDATE_MEGA_DATABASE