This statement turns the optimizer's timeout feature on and off. If timeout is on (the default), the query optimizer stops checking query execution plans when it believes that the best plan that it has found takes less time to execute than the amount of time already spent searching for a plan. If you issue a set joinop notimeout statement, the optimizer does not time out when checking query execution plans.

This option is often used with the set qep option to ensure that the optimizer is picking the best possible query plan.

The default is set joinop timeout.