View a QEP
In general, it is a good idea to test run a query (that is, view the QEP).
In VDBA, if you open the SQL Scratchpad window and click Execute QEP, you automatically see the query execution plan in a graphical form. For step-by-step instructions, see Viewing the Query Execution Plan in online help.
From a terminal monitor or embedded SQL, you can see the QEP by using the SET QEP statement. On the SET statement, the [NO]OPTIMIZEONLY, [NO]QEP, and JOINOP [NO]TIMEOUT clauses pertain to QEPs. The QEP is displayed in text-only format when using SQL.
Control QEP Generation Using a Environment Variable
To control whether QEPs are generated using an operating system environment variable, issue the following commands:
Windows:
set ING_SET=set qep
UNIX:
C shell:
setenv ING_SET "set qep"
Bourne shell:
ING_SET = "set qep"
export ING_SET
VMS:
define ING_SET "set qep"
Last modified date: 08/28/2024