aiaiDBA

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

13718043309

010-86462881

QSM-02059: join may produce duplicate rows in mv

QSM-02059: join may produce duplicate rows in mv
Cause: The capability in question is not supported when the materialized view contains a join condition that can result in duplicate rows in the materialized view.
Action: Re-phrase the query to avoid the occurrence of duplicate rows in the materialized view.

请先 登录 后评论

1 个回答

小智
QSM-02059:join可以以mv生成重复的行,
.原因:当物化视图包含可能在物化视图中导致重复行的连接条件时,不支持相关功能。,
.操作:重新排序查询以避免在物化视图中发生重复的行。,
.
请先 登录 后评论