Oracle Error Message
QSM-00508: statistics missing on tables/columns
Reason for the Error
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.
Solution
Run ANALYZE on the tables and summaries in the warehouse to collect statistics