Vector 6.0 | Control Optimizer Timeout

User Guide > User 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 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

Last modified date: 11/09/2022