HPE NonStop SQL/MX Error – 9225 No histogram data is available for columns column-list.

In this blog post, let’s learn about the error message “9225 No histogram data is available for columns column-list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

9225 No histogram data is available for columns column-list.

Reason for the Error

Histograms for the specified columns in the column-list are not available.

Solution

Run UPDATE STATISTICS command with column-list, and then rerun the SHOWSTATS command