If the scanned SQL statement is valid, the access plan for the SQL statement will be retrieved. The access plan is a combination of steps the DB2 LUW optimizer selects to execute the SQL statement. It is a sequential set of steps required to carry out the query, complete with the access methods chosen for each table.
Examination of the access plan shows how the database executes the SQL statement and aids in the analysis of whether the SQL statement is the most efficient.
The access plan help provides online help for each operation within the access plan to help you understand each step of the plan.
To view the help for an operation
Right-click the access plan step for which you want help and select Get help on operation_name.