In this blog post, let’s learn about the error message “9202 UPDATE STATISTICS has located previously generated histograms that are not being regenerated. This may affect the plans that will be generated. Missing column lists are column-list.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9202 UPDATE STATISTICS has located previously generated histograms that are not being regenerated. This may affect the plans that will be generated. Missing column lists are column-list.
Reason for the Error
UPDATE STATISTICS has located previously generated histograms that are not being regenerated.
Solution
Remove or replace previously generated histograms by performing either one of these two recovery actions:
Re-execute the same UPDATE STATISTICS command, but also include the column-list from the message.
Perform UPDATE STATISTICS FOR the table. Then re-execute UPDATE STATISTICS with the column lists in which you are interested