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.

Before you begin...

To dynamically explain an SQL statement:

1. Open the Explained Statements History window.

2. Highlight one or more statements and select Statement->Explain SQL. An Explain SQL Statement window opens for each statement that is selected. The SQL text field is populated with the selected text.

   If no statements are selected, the Explain SQL Statement window opens. SQL text field is empty.

3. Press F1 or click on the Help push button for instructions on how to use this window.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]