Have you tried gathering statistics to see whether the optimizer does any better? or does JD Edwards use the Rule based optimizer?