In this blog post, let’s learn about the error message “9226 The SAMPLE clause is ignored when specified with NECESSARY clause.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9226 The SAMPLE clause is ignored when specified with NECESSARY clause.
Reason for the Error
Sampling option is specified along with NECESSARY COLUMN[S] option of UPDATE STATISTICS command.
Solution
None
