8. SQL Statements : SET : Joinop [No]Greedy
 
Share this page                  
Joinop [No]Greedy
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.