aiaiDBA

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

13718043309

010-86462881

QSM-01093: anti-join marker not found in materialized join view

QSM-01093: anti-join marker not found in materialized join view
Cause: Materialized join view has outer join while the query 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-01093:在物化连接视图中找不到反连接标记,
.原因:实体化连接视图具有外部连接,而查询内部连接。为了重写成功,MV必须具有反连接标记,例如外连接的右表的rowid或主键,
.行动:无,
.
请先 登录 后评论