QSM-00508: statistics missing on tables or columns

QSM-00508: statistics missing on tables or 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

No comments:

Post a Comment