A data source node represents
a physical data
store in the database, such as a table or index.
Buffer table node
A buffer table node represents a buffer table,
which is
an in-memory table that stores the inserted records of an INSERT clause
within a SELECT statement that also includes a VALUES clause.
Common table expression node
A common table expression
node represents a work file that
is generated by a common table expression in an SQL statement.
DOCID node
A DOCID index node represents a DOCID index, which maps
a DOCID list to a RID list
Index node
An index node represents an index that is referenced by
the SQL statement. An SQL statement can reference the same index multiple
times; each reference is represented by an index node.
IN-MEMORYTABLE node
An IN-MEMORYTABLE node represents an in-memory table that
stores the IN-list predicates.
Materialized query table node
A materialized query table node represents a materialized
query table that is referenced in the SQL statement. A materialized
query table stores the results of common subqueries and is used to
speed up complex online analytical processing (OLAP) queries.
Pipe node
A pipe node represents a pipe, which is a virtual temporary
table that is created during a star join or UNION ALL operation. A
pipe effectively represents a "not-materialized" work file.
Table node
A table node represents a table that is referenced in the
SQL statement. The referenced table can be a base table, a global
temporary table, or a view.
Table function node
A table function node represents a table function
that
is invoked by the SQL statement.
Sparse index node
A sparse index node represents an in-memory
sparse index
that is dynamically generated by DB2 for
an inner table without a suitable index during a nested loop join.
Star join dimension work file node
A star join dimension
work file node represents a work
file that results from the sorting of a dimension table or another
star join dimension work file during a data manager pushdown star
join.
Virtual index node
The virtual index node represents a virtual
index for the
purposes of what-if analysis.
Virtual table node
The virtual table node represents a virtual
table, which
is different that a general work file.
XML INDEX node
XML INDEX node represents an XML index, which contains
the composite key values and maps the XML values to the DOCID and
NODEID pairs.
Work file node
A work file node represents a work file, which is a temporary
table that DB2 generates