In this blog post, let’s learn about the error message “9223 The statement will have no effect because no histograms need to be updated.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9223 The statement will have no effect because no histograms need to be updated.
Reason for the Error
The UPDATE STATISTICS statement with NECESSARY COLUMN[S] option is submitted when there are no column combinations for which statistics need to be updated.
Solution
The NECESSARY COLUMN[S] option must be used to regenerate the statistics when the data in the table is changed considerably since the execution of earlier UPDATE STATISTICS command
