Use the SQL Text window to view the text for an explained SQL
statement.
Authorities and privileges
To view text for an SQL statement:
- Create an access plan using the Command
Center.
- Do one of the following:
- Select Access plan->Statement->Show SQL text.
- Deselect all nodes in the graph. Click
mouse button 2 on the graph background and select Show SQL text
from the pop-up menu.
The SQL Text window opens. The SQL text field is
populated with the SQL statement whose access plan is shown in the
graph.
- Press F1 or click the Help push button for
instructions on how to use this window.
Related information