Interpreting data access by using EXPLAIN

You can use the values captured in EXPLAIN tables, and instances of PLAN_TABLE in particular, to analyze how Db2 accesses data when it processes a particular SQL statement.

Tip: You can use tools such as IBM® Data Server Manager and related Db2 Tools for z/OS® solutions to simplify this task.
Tip: You can use the visual explain feature of tools such as IBM Data Server Manager to create visual diagrams of the access paths for your SQL statements.