SQL text
Query number
Query tag
Optimization class
Populate all columns in Explain tables
Get
Save
OK
Cancel
SQL text
Query number
Query tag
Optimization class
Populate all columns in Explain tables
Get
Save
OK
Cancel
SQL text
In the SQL text field, type the query that you want to be explained. If the SQL text is already populated with the statement that you selected in the last window, you can modify the text.
Use the Get push button to get the SQL text from a specified file.
Use the Save push button to store the query in the SQL text box to a specified file.
Query number
Type a new query number to be associated with this dynamic explain.
Query tag
Type a short comment to be associated with this dynamic explain.
Optimization class
Use this field to specify the optimization class. You can select the up or down arrow to spin through the available choices.
Populate all columns in Explain tables
Select this check box if you want all columns of explain tables to be populated from the dynamic explain; otherwise, only the few columns needed by Visual Explain are populated from the dynamic explain.