In this blog post, let’s learn about the error message “6008 Statistics for column column-name from table table-name were not available. As a result, the access path chosen might not be the best possible.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
6008 Statistics for column column-name from table table-name were not available. As a result, the access path chosen might not be the best possible.
Reason for the Error
Statistics for the column were not generated.
Solution
Generate the statistics for the column identified in the warning, and prepare the query again