How to fix the Oracle error QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics?

In this post, you’ll learn more about the Oracle ErrorQSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

Reason for the Error QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics

The user attempted to add a workload statement that contains a table without statistics. Access Advisor requires all referenced tables to have valid statistics.

How to fix the Error QSM-00792: the specified SQL statement cannot be stored in the workload because one or more tables have missing statistics ?

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

Validate the workload statement and retry the operation.