Performing Repository Regular Maintenance Tasks
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