QSM-00508: statistics missing on tables/columns

QSM-00508: statistics missing on tables/columns
Cause: The system metadata does not contain statistics on one or more tables or columns. The Advisor needs cardinalities of all fact-tables, and of the level-keys of all dimensions in the data warehouse.
Action: Run ANALYZE on the tables and summaries in the warehouse to collect statistics

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-00508：表/列上缺少统计信息,
.原因：系统元数据不包含一个或多个表或列的统计信息。顾问需要所有事实表的基数以及数据仓库中所有维度的级别关键字。,
.操作：对仓库中的表和摘要运行ANALYZE以收集统计信息,
.

aiaiDBA

13718043309

010-86462881

QSM-00508: statistics missing on tables/columns

1 个回答

相似问题