Using Visual Explain for routines

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.

Related concepts
Creating stored procedures
Creating user-defined functions (UDFs)
Related tasks
Creating database routines
Related information
Analyzing SQL statements with Visual Explain

Feedback