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.

No comments:

Post a Comment