Using Visual Explain for SQL statements

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:

After you open Visual Explain, click the Help button on the Visual Explain toolbar for detailed information about how to use the tool.
Related tasks
Using Visual Explain for routines

Feedback