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.