Try OpenEdge Now
skip to main content
New Information
OpenEdge DataServers : -nojoinhint startup parameter
 

-nojoinhint startup parameter

Starting this release, the startup parameter -nojoinhint is introduced for the DataServer for Oracle. This parameter overrides the USE_MERGE default query-tuning hint for OUTER-JOIN queries. If only a few records are needed out of a large result set, the USE_MERGE default can be inefficient.
Disable the USE_MERGE hint by compiling your ABL application with the -nojoinhint client startup parameter.
The -nojoinhint parameter is for compile time only. It has no impact on run time.
For more information, see Join Hint (-nojoinhint).