Dynamically explaining an SQL statement

Use the Explain SQL Statement window to dynamically explain an SQL statement and produce an access plan graph. If explain tables do not exist, they will be created.

An explained statement record is added to the Explained Statements History for all successful operations.

Fields and controls

Authorities and privileges

To dynamically explain an SQL statement:

1. Open the Explain SQL Statement window.

2. In the SQL text field, you can:

   • Enter an SQL statement that you want explained

   • Change the text of an SQL statement, which is already populated in the text field.

   • Use the Get push button to get an SQL statement from a specified file.

   • Use the Save push button to save the SQL statement to a specified file.

3. Optional. Either accept the defaults or enter new values for Query number or Query tag fields.

4. Optional. Either accept the default or select a different value for Query optimization class.

5. Optional. Select the Populate all columns in Explain tables 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.

6. To dynamically explain the SQL statement, click on OK.

Related information

• Creating an access plan graph
• Viewing explainable statements for a package
• Viewing the history of previously explained SQL statements
• Viewing a graphical representation of an access plan
• Using Visual Explain windows and notebook