IBM Books

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.
Figure rule not displayed.

Before you begin...
Figure rule not displayed.

To dynamically explain an SQL statement:

  1. Open the Explain SQL Statement window.

  2. 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 ]