Query Optimization on Product Queries

The SQL profiler report may also show top select statements that include heavy logical reads or that consume heavy CPU cycles. These can be external queries which may not be executed by TIBCO MDM but communicate with TIBCO MDM. Based on regular observation, you may need to tune these types of queries. You can contact TIBCO MDM engineering for more information.