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 Access Plan Graph window.

2. Do one of the following:

   • Select Statement->Explain SQL.

   • Deselect all nodes in the graph. Click mouse button 2 on the graph background and select Explain SQL from the pop-up menu.

   The Explain SQL Statement window opens. The SQL text field is populated with the SQL statement whose access plan is shown in the graph.

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 ]