Dynamic Query Mode governor for Multi Fact Nonshared Dimensions

As of release 12.1.1, you can use the Dynamic Query Mode (DQM) Multi Fact Non-Shared Dimensions governor to suppress stitch queries, which are based on multi-fact stream queries that include nonshared dimensions.

DQM might generate an SQL pattern for a multi-fact query. If a database administrator observes and confirms that their system experiences performance issues that align with the generated pattern, they can enable this option for testing purposes.

For more information, see the (DQM) Multi Fact Non-Shared Dimensions section in Dynamic query mode governors.