Common Explain

The Common Explain technology enables you to Explain dynamic and static SQL statements. Common Explain provides both statistical and textual information about the access path, and suggests how to improve SQL statement performance.

(PTF BQU1326 and BQU1107 applied) For DB2 Version 11 or later, ensure that you install the ADMIN_EXPLAIN_MAINT stored procedure. For details about installing the stored procedure, see Installing the ADMIN_EXPLAIN_MAINT stored procedure in the "Required authorities for Workload Advisor Explains and the Index Advisor feature" topic.