Join Hint (-nojoinhint)

Use Join Hint (-nojoinhint) to override the USE_MERGE default query-tuning hint for OUTER-JOIN queries.

Operating system and syntax	UNIX / Windows	-nojoinhint
Use with	Maximum value	Minimum value	Single-user default	Multi-user default
DataServer Client	—	—	—	—

For the DataServer for Oracle only, -nojoinhint disables 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.