aiaiDBA

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

13718043309

010-86462881

QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query

QSM-01271: query rewrite not possible because a join in materialized view string with table string has eliminated some rows found in query
Cause: A join from the materialized view to any table that eliminates some rows should be be present in the query. Otherwise query rewrite will not occur.
Action: None

请先 登录 后评论

1 个回答

小智
QSM-01271:查询重写不可能,因为使用表字符串的实例化视图字符串中的连接已经消除了查询中发现的一些行,
.原因:从物化视图到任何消除某些行的表的连接都应该存在于查询中。否则不会发生查询重写。,
.行动:无,
.
请先 登录 后评论