Database maintenance

You need to maintain the Content Manager OnDemand database to keep it performing in an optimal manner. Run the following database maintenance tasks on a regular basis:

• Collect statistics on tables to keep optimization information up-to-date
• Remove index data that has reached its life of data and indexes period
• Migrate indexes to archive storage, if your organization needs to keep indexes for some period of time after users no longer need to retrieve the documents to which they point