QSM-01125: a more optimal set operator materialized view than string was used to rewrite

QSM-01125: a more optimal set operator materialized view than string was used to rewrite
Cause: Query Rewrite always chooses the most optimal set operator materialized view based on parameters, such as cardinality of the set operator materialized view, number of branches that the set operator materialized view can rewrite etc. The set operator materialized view specified was found to be less optimal.
Action: To force using a set operator materialized view, consider using a rewrite hint.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01125：一个比字符串更优化的集合操作符物化视图用于重写,
.原因：查询重写总是基于参数（如集合操作符物化视图的基数，集合操作符实例化视图可重写的分支数等）选择最优集合操作符实例化视图。指定的集合操作符实例化视图为不太优化。,
.操作：要强制使用设置操作符实例化视图，请考虑使用重写提示。,
.

aiaiDBA

13718043309

010-86462881

QSM-01125: a more optimal set operator materialized view than string was used to rewrite

1 个回答

相似问题