This statement enables or disables the complex query enumeration heuristic of the query optimizer. The greedy heuristic enables the optimizer to produce a query plan much faster than with its default technique of exhaustive searching for query execution plans when the query references a large number of tables. For details on the greedy optimization heuristic, see the Database Administrator Guide.

When SET JOINOP GREEDY is specified, the SET JOINOP TIMEOUT statement has no effect.