In this blog post, let’s learn about the error message “6007 Multi-column statistics for columns names from table namewere 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
6007 Multi-column statistics for columns names from table namewere not available; as a result, the access path chosen might not be the best possible.
Reason for the Error
Statistics are not available for the multicolumn join you are performing.
This message appears when the user has not updated statistics for column names and when the rowcount in table name is more than the value of the defaults table constant HIST_ROWCOUNT_REQUIRING_STATS. If you want to suppress this message, set that value to a large number, and you will see this message only for tables with more rows than that, and for which there are no updated statistics.
Solution
None
