Database Optimizations

Periodically, run the database maintenance and optimization tools to identify queries that take a longer time and add indexes to these queries.

If one repository is being used extensively, place indexes in that repository against the most searched attributes.

To reduce the database overhead, remove indexes that do not provide any value. Do not remove product out-of-the-box indexes.

Use the TIBCO MDM Purge feature to purge all the older versions of the records that are being stored but never used.

Copyright © Cloud Software Group, Inc. All rights reserved.