QSM-00510: statistics missing on materialized views

QSM-00510: statistics missing on materialized views
Cause: The system metadata does not contain statistics on one or more materialized views. The Advisor needs cardinalities of all materialized views in the data warehouse.
Action: Run ANALYZE on the tables and materialized views in the warehouse to collect statistics.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-00510：物化视图中缺少统计信息,
.原因：系统元数据不包含一个或多个物化视图的统计信息。顾问需要数据仓库中所有物化视图的基数。,
.操作：对仓库中的表和物化视图运行ANALYZE以收集统计信息。,
.

aiaiDBA

13718043309

010-86462881

QSM-00510: statistics missing on materialized views

1 个回答

相似问题