In this blog post, let’s learn about the error message “9222 The statement will have no effect because no histograms are available for the table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9222 The statement will have no effect because no histograms are available for the table.
Reason for the Error
The UPDATE STATISTICS statement with EXISTING COLUMN[S] or NECESSARY COLUMN[S] option is submitted when there are no statistics available for the table.
Solution
Generate statistics at least once on the table, and then use the EXISTING COLUMN[S] or NECESSARY COLUMN[S] to regenerate the statistics
