Database Administrator Guide > Database Administrator Guide > Using the Query Optimizer > Optimizer Timeout > Control Optimizer Timeout
Was this helpful?
Control Optimizer Timeout
By default, the optimizer times out, but you can turn the timeout feature off to enable the query optimizer to evaluate all plans.
To control optimizer timeout
To turn the timeout feature off, issue the following SQL statement (for example, from Actian Director, the VDBA SQL Scratchpad window, from a terminal monitor, or from within an embedded SQL application):
set joinop notimeout
To turn the timeout feature back on, issue the corresponding statement:
set joinop timeout
To control this feature using an operating system environment variable:
Windows:
set ING_SET=set joinop notimeout
Linux:
ING_SET = "set joinop notimeout"
export ING_SET
Last modified date: 04/03/2024