You can use Visual Explain to view explained SQL statements as
a graph. You can use the information available from the graph to tune your
SQL queries for better performance. The nodes in the graph represent tables
and indexes and each operation on them. The links between the nodes represent
the flow of data.
In the SQL builder, Visual Explain is only supported for a single
DML statement.
Visual Explain is available on the Windows
® platform.
The following servers are supported:
- DB2™ Version
9.1 for Linux®, UNIX®,
and Windows
- DB2
Universal Database for Linux, UNIX, and Windows, Version 8.2 FixPak 8
- DB2® for z/OS®
Prerequisite: The SQL statement must exist in a
data development project.
To use Visual Explain for an SQL statement:
- If the statement is open in the SQL builder, click .
- In the Data Project Explorer:
- Expand a data development project, and then expand its SQL
Scripts folder.
- Right-click an SQL statement, and then click Visual
Explain on the pop-up menu.
After you open Visual Explain, click the Help button on the Visual
Explain toolbar for detailed information about how to use the tool.