Use the SQL Text Entry window and its associated SQL Text
Edit panel to enter an SQL statement to be explained.
To display this window, select option 4 from the Explain Menu. Figure 1. SQL Text Entry window
DGOMYWES SQL Text Entry
Enter query number if needed, then press Enter to display the SQL Text
Edit panel.
Query number . . . . . . . . . . . 999735912
Set current degree to ANY
F1=Help F2=Split F3=Exit F9=Swap F12=Cancel
In this window, enter the query number you want to assign to the
SQL statement. The query number identifies in the plan table the SQL
statement that you are entering. If no query number is specified,
the default is 999 735 912.
The 1 field specifies whether the SQL statement
is eligible for query parallelism. If you enter a forward slash (/)
in this field, the current degree of parallelism is set to ANY. Otherwise,
the current degree of parallelism is set to 1.
After you press Enter, the Edit SQL Text panel is displayed, where
you can enter the SQL statement text you want to explain.