In this blog post, let’s learn about the error message “9212 Cardinality statistics will be more accurate if you use the SET ROWCOUNT option in the SAMPLE clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9212 Cardinality statistics will be more accurate if you use the SET ROWCOUNT option in the SAMPLE clause.
Reason for the Error
The SET ROWCOUNT option was not used in the SAMPLE clause.
Solution
Provide SET ROWCOUNT option and resubmit for more accurate statistics