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 a query tab in Director, from 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:
C shell:
setenv ING_SET "SET JOINOP NOTIMEOUT"
Bourne shell:
ING_SET = "SET JOINOP NOTIMEOUT"
export ING_SET