QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause

QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause
Cause: The capability in question was not supported because the materialized view query contained an ORDER BY clause.
Action: Rephrase the query to avoid the use of the ORDER BY clause.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02202：如果查询具有ORDER BY子句，PCT FAST REFRESH是不可能的,
.原因：由于物化视图查询包含ORDER BY子句，所以不支持该功能。,
.操作：重新执行查询以避免使用ORDER BY子句。,
.

aiaiDBA

13718043309

010-86462881

QSM-02202: PCT FAST REFRESH is not possible if query has ORDER BY clause

1 个回答

相似问题