In this blog post, let’s learn about the error message “20421 Index index-name1 must be on the same columns as index-name2, in the same sequence, and with the same ascending/descending specification.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20421 Index index-name1 must be on the same columns as index-name2, in the same sequence, and with the same ascending/descending specification.
Reason for the Error
The model index for a MODIFY INDEX … REPARTITION has a different index column specification than the target index.
Solution
Specify a model index that is on the same set of columns as the target index, in the same sequence, and with the same ascending/descending specification
