Performing EXPLAIN


EXPLAIN is a performance tuning command provided by DB2/VM. It shows the access path chosen by the DB2/VM Optimizer for a given SQL request.

As the first step of an analysis, SQL/CA performs EXPLAIN for all SQL statements in the application. It then formats the numerical and encoded SQL EXPLAIN results into an interactive, easily readable analysis report.

SQL/CA further enhances the EXPLAIN results: