IN-MEMORYTABLE node

An IN-MEMORYTABLE node represents an in-memory table that stores the IN-list predicates.

An IN-MEMORYTABLE node is labeled with a name that DB2® specifies and the default shape for this type of nodes is a rectangle.

DB2 accesses an IN-MEMORYTABLE table by using the INLIST operation.

The information that is displayed in the node consists of these elements in this order:
  1. Node ID
  2. Table name
  3. IN-list predicate number
  4. Query-block number

Feedback