QSM-01222: materialized view string is less optimal than string

QSM-01222: materialized view string is less optimal than string
Cause: Query Rewrite always chooses the most optimal materialized view based on certain parameters, such as cardinality of the materialized view, number of joins etc. The materialized view specified was found to be less optimal.
Action: To force using a materialized view, consider using a rewrite hint.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01222：物化视图字符串不如字符串最佳,
.原因：查询重写总是基于某些参数选择最优化的物化视图，如物化视图的基数，连接数等。指定的物化视图被认为不太理想。,
.操作：要强制使用实例化视图，请考虑使用重写提示。,
.

aiaiDBA

13718043309

010-86462881

QSM-01222: materialized view string is less optimal than string

1 个回答

相似问题