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.

A pipe node is labeled with the name that DB2® specifies and the default shape for this type of nodes is a pipe segment.

How DB2 accesses a pipe

DB2 uses a table space scan (TBSCAN) to access a pipe.

The optimizer treats a pipe as a work file with a specific name and determines the access plan accordingly.


Feedback