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

QSM-01084: 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 either lossy or lossless 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-01084：物化视图字符串在查询中没有找到锚表字符串,
.原因：实体化视图中的表是锚点，（a）如果未连接到任何其他表或（b）连接到其他表，但是每个连接均为有损或无损，上表为子方表。如果查询中找不到物化视图中存在的锚点，则不会发生查询重写。,
.行动：无,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题