In this blog post, let’s learn about the error message “4174 JOIN_ORDER_BY_USER prevented compiler from reordering query tree.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4174 JOIN_ORDER_BY_USER prevented compiler from reordering query tree.
Reason for the Error
The SQL/MX compiler could not reorder the join tree because the JOIN_ORDER_BY_USER directive is in effect.
Solution
Disable the JOIN_ORDER_BY_USER directive and resubmit
