QSM-01284: materialized view string has an anchor table string not found in query

QSM-01284: materialized view string has an anchor table string not found in query
Cause: A table in a materialized view is an anchor, (a) if it is not joined to any other table or (b) joined to other tables but each of its joins is not guaranteed to provide all the rows or joined with the above table being child-side table. If an anchor which is present in the materialized view is not found in the query, then query rewrite will not take place.
Action: None

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01284：物化视图字符串在查询中没有找到锚表字符串,
.原因：物化视图中的表是一个锚点，（a）如果没有连接到任何其他表或（b）连接到其他表，但是每个连接不能保证提供所有行或与上述连接桌子是小孩桌子。如果查询中找不到物化视图中存在的锚点，则不会发生查询重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

QSM-01284: materialized view string has an anchor table string not found in query

1 个回答

相似问题