Explain SQL statements - Documentation for BMC AMI SQL Explorer for Db2 13.1

In SQL Explorer, running an Explain job explains the steps that the Db2 optimizer must take to execute the relevant SQL statements.

You can run an Explain job to see an explanation of any of the following types of statements:

• All explainable SQL statements in a plan or package

• SQL statements stored outside the Db2 catalog (referred to as a DBRM library Explain or DBRMLIB Explain)

• A single SQL statement (online or in batch mode)