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 lamp;lt;lamp;nbsp;pk-listlamp;gt;, lamp;lt;lamp;nbsp;ref-collamp;gt; from mjv) where lamp;lt;lamp;nbsp;pk-listlamp;gt; is the list of rowids or pk of all mjv tables that don t correspond to a right side of a semi-join and lamp;lt;lamp;nbsp;ref-collamp;gt; are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action: none
Cause: If there is a semi join in the query, then Query Rewrite will create (select distinct lamp;lt;lamp;nbsp;pk-listlamp;gt;, lamp;lt;lamp;nbsp;ref-collamp;gt; from mjv) where lamp;lt;lamp;nbsp;pk-listlamp;gt; is the list of rowids or pk of all mjv tables that don t correspond to a right side of a semi-join and lamp;lt;lamp;nbsp;ref-collamp;gt; are their columns. Query Rewrite will not occur if a join from the materialized view cannot match the semi-join from the query.
Action: none
No comments:
Post a Comment