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.

A buffer table node is labeled with the name of the referenced table, and the default shape for this type of node is a trapezoid.

How DB2 accesses a buffer table

DB2® uses a buffer table scan (BTBSCAN) to access a buffer table.

The number of rows in a buffer table is equal to the number of records in the VALUES clause. DB2 uses this information to determine the access plan.


Feedback