The following nodes can appear in representations of access
plans for the SQL statements that run on DB2® for z/OS®.
Data source nodes
A data source node represents
a physical data
store in the database, such as a table or index.
Operator nodes
An operator node represents an action that
is performed on data or on the output from a table or an index when
the access plan is executed.
Join nodes
Join nodes represent relational join operations
that allow retrieval of data from two or more tables based on matching
column values.
Auxiliary nodes
An auxiliary node, includes any node that
is neither a data source node nor an operator nodes.