aiaiDBA

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

13718043309

010-86462881

QSM-01293: anti-join marker not found in materialized view with joins

QSM-01293: anti-join marker not found in materialized view with joins
Cause: Materialized view has outer join while the query has inner join. For rewrite to succeed MV must have an anti-join marker like the rowid or primary key of the right tables of outer join
Action: None

请先 登录 后评论

1 个回答

小智
QSM-01293:在连接的物化视图中未找到反连接标记,
.原因:物理视图具有外连接,而查询具有内连接。为了重写成功,MV必须具有反连接标记,例如外连接的右表的rowid或主键,
.行动:无,
.
请先 登录 后评论