Generating access plan graph

Access plan graph is a visual representation of an access plan. You can choose to generate an access plan graph for selected SQL statements that reside on a connected Db2 subsystem, by using appropriate tuning options.

About this task

Access plan graph describes both the operational details of query execution and how the data flows. A leaf node of an access plan graph is either a table node, or an index node that represents a data source in the query execution plan. Typically, a table node is at the bottom of the graph, and the access plan proceeds upward from there.

Procedure

To generate an access plan graph:

  1. Create a tuning task for a single query or workload, with the Generate access plan graph tuning option selected.
  2. When the tuning task is completed, go to Tuning > Tuning results page to view the result list.
  3. In the Tuning results page, select the tasks with the Result displaying as Success and click View result.
    The Advisor recommendations page displays.
    • To view the access path graph for a single query result, click the Access plan graph tab.
    • To view the access path graph for a workload tuning result, click the View all statements tab, choose one statement from the list then click Access plan graph in the drop-down menu.