HPE NonStop SQL/MX Error – 4174 JOIN_ORDER_BY_USER prevented compiler from reordering query tree.

Data 16 Views 1 Min Read

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

Tags: