Explain dynamic SQL statement

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.