Hello
Does anyone know if this governor applies only to relational database or for cubes (TM1) as well ?
(DQM) Master-detail optimization
Thanks
Quote from: fry on 11 Aug 2016 04:18:14 PM
Hello
Does anyone know if this governor applies only to relational database or for cubes (TM1) as well ?
(DQM) Master-detail optimization
Thanks
Hi fry,
It's relational only. Here's a quote from IBM docs below:
QuoteUse this governor to control whether detail query caching occurs for a relational master-detail query. To minimize the amount of SQL execution against the database for detail queries, cache the detail query. For example, if you have 1000 detail queries then only one SQL execution will occur. By default, detail queries are not cached, so for 1000 detail queries, 1000 SQL executions occur.
Master detail optimizations are applied for both OLAP and relational systems.