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.

Authorities and privileges

To dynamically explain an SQL statement:

1. Create an access plan using the Command Center.

2. Do one of the following:

   • Select Access plan->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.

Related information

• Command Center -- Access Plan