Ingres 11.2 | Control Optimizer Timeout

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

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"

Last modified date: 08/28/2024