The SQL explain facility is part of the SQL Compiler that can be used to capture information about the environment where the static or dynamic SQL statement is compiled. The information captured allows you to understand the structure and potential execution performance of SQL statements, including:
This information can help you:
The following topics are provided:
The explain output is stored in relational tables and, as an option, in a format which may be graphically displayed using the Visual Explain tool. You should consider using the explain tables to find those queries that are of interest to you. For more information on the tables used by the explain facility and how to create those tables, see Appendix M. "Explain Tables and Definitions".
[ DB2 List of Books | Search the DB2 Books ]