How to fix the Oracle error QSM-00508: statistics missing on tables/columns?

In this post, you’ll learn more about the Oracle ErrorQSM-00508: statistics missing on tables/columns with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-00508: statistics missing on tables/columns

Reason for the Error QSM-00508: statistics missing on tables/columns

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.

How to fix the Error QSM-00508: statistics missing on tables/columns ?

You can fix this error in Oracle by following the below steps

Run ANALYZE on the tables and summaries in the warehouse to collect statistics