QSM-01049
semi-join check failed for materialized view, string
Cause
If there is a semi join in the query, then Query Rewrite will create (select distinct pk-list, ref-col from mjv) where pk-list is the list of rowids/pk of all mjv tables that don't correspond to a right side of a semi-join and ref-col are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action
QSM-01049
semi-join check failed for materialized view, string
Cause
If there is a semi join in the query, then Query Rewrite will create (select distinct pk-list, ref-col from mjv) where pk-list is the list of rowids/pk of all mjv tables that don't correspond to a right side of a semi-join and ref-col are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action
QSM-01049
semi-join check failed for materialized view, string
Cause
If there is a semi join in the query, then Query Rewrite will create (select distinct pk-list, ref-col from mjv) where pk-list is the list of rowids/pk of all mjv tables that don't correspond to a right side of a semi-join and ref-col are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action
