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
Unix:
C shell:
setenv ING_SET "set joinop notimeout"
Bourne shell:
ING_SET = "set joinop notimeout"
export ING_SET
VMS:
define ING_SET "set joinop notimeout"