You can use Visual Explain for routines to view the 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.
Visual Explain is available on the Windows
® platform. The following servers
are supported:
- DB2® for Linux®, UNIX®,
and Windows,
Version 8.2 FixPak 8
- DB2 for z/OS®
You can open Visual Explain for routines from the following wizards
and editors in the workbench:
- New Stored Procedure wizard
- New User-Defined Function wizard
- Stored procedure editor
After you open Visual Explain, click the Help button on the interface
for more detailed information about how to use the tool.