Chapter 25. Using EXPLAIN

You can use the EXPLAIN feature to detail the access paths chosen by the DB2 optimizer for SQL statements. EXPLAIN should be a key component of your performance monitoring strategy. The information provided by EXPLAIN is invaluable for determining the following:

• The work DB2 does “behind the scenes” to satisfy a single SQL statement

• Whether DB2 uses available indexes and, if indexes are used, how DB2 uses them

• Whether ...

Get DB2 Developer’s Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.