Dynamically explaining an SQL statement

To display an access plan graph by dynamically explaining an SQL statement, follow these steps:

1. In the Control Center, select the database you want, and click mouse button 2.
2. Select Explain SQL from the pop-up menu. The Explain SQL Statement window opens.
3. Enter an explainable statement, and click on OK. The Access Plan Graph window opens, showing the access plan graph for the explained statement.

The Explain SQL function can also be invoked from the Explainable Statements window, the Explained Statements History window, and the Access Plan Graph window.