(DQM) Master-detail optimization Govenor

[fry]

Hello

Does anyone know if this governor applies only to relational database or for cubes (TM1) as well ?

(DQM) Master-detail optimization


Thanks

[AnalyticsWithJay]

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:

Use 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.

[the6campbells]

Master detail optimizations are applied for both OLAP and relational systems.