aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-01110: query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query

QSM-01110: query rewrite not possible with materialized view string because it contains a join between tables (string) that is not present in the query and that potentially eliminates rows needed by the query
Cause: All lossy joins in the materialized view must be present in the query for query rewrite to occur.
Action: None

请先 登录 后评论

1 个回答

小智
QSM-01110:使用实例化视图字符串查询重写不可能,因为它包含查询中不存在的表(字符串)之间的连接,并且可能消除查询所需的行,
.原因:物化视图中的所有有损耦合必须存在于查询中才能发生查询重写。,
.行动:无,
.
请先 登录 后评论