DB2 Version 9.7 for Linux, UNIX, and Windows

Access plan graph

Visual Explain uses information from a number of sources in order to produce an access plan graph

Based on various inputs, as shown in the illustration below, the optimizer chooses an access plan, and Visual Explain displays it in an access plan graph. The nodes in the graph represent tables and indexes and each operation on them. The links between the nodes represent the flow of data.

Access plan graph diagram