Database Error Messages

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.