Query Optimization

New for CMOD in 2020, CMOD.cloud now offers assistance with IBM Content Manager OnDemand Query Optimization. Using the latest version of our proprietary OnDemand reporting tool, we’re able to quantify the most heavily utilized fields in OnDemand, allowing administrators to take the guesswork out of optimization, and eliminates the need for database administrators to investigate performance issues. DBA’s rarely understand CMOD at a deep enough level to configure it optimially, and keep it optimized.

What is Query Optimization? Inside Content Manager OnDemand, there are built-in configuration items for creating field indexes at the database level, including Composite Indexes.

Using the Field Frequency report, you can both identify the fields that derive the most benefit from enabling indexing, as well as the fields where indexing can be disabled without impacting performance – saving space (and dollars!) of some of your fastest, most expensive disk.

Interested in learning more? Just call +1-833-533-7742 (Toll Free in US & Canada) and schedule some time to talk about your requirements.