In this blog post, let’s learn about the error message “23028 Statistics of the table table-name is cleared.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
23028 Statistics of the table table-name is cleared.
Reason for the Error
The target table already contains statistics and KEEPSTATS option is set to OFF.
Solution
To avoid statistics from being cleared, set KEEPSTATS option to ON
