In this blog post, let’s learn about the error message “4207 Index name and other indexes covering a subset of columns do not cover all output values of stream.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4207 Index name and other indexes covering a subset of columns do not cover all output values of stream.
Reason for the Error
You attempted to use an index for stream access that does not cover all output columns of the base table.
Solution
Restrict the select list or add the missing columns to the index
