D
dbeavon
Guest
It should be replaced with a more explicit keyword (maybe "USE-INDEX-WITHOUT-MULTIPLE-BRACKETING"). PDSOE's auto-completion should help with that. 
I ran into the same confusing issue that Rob originally described, only at run-time with a dynamically-created QUERY-PREPARE statement. The index is fine and I do want to use it. But what is counter-intuitive is where OE decides it cannot use the index more than *once*. Because of that decision on OE's part, the keyword essentially becomes self-defeating.
Continue reading...
I ran into the same confusing issue that Rob originally described, only at run-time with a dynamically-created QUERY-PREPARE statement. The index is fine and I do want to use it. But what is counter-intuitive is where OE decides it cannot use the index more than *once*. Because of that decision on OE's part, the keyword essentially becomes self-defeating.Continue reading...