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.

A sparse index is an array of join keys and RIDs. When no indexes are defined on the table and the table is small, a sparse index can greatly improve performance.

A sparse index node is labeled SPARSEINDEX and is, by default, displayed as a diamond.

How DB2 accesses a sparse index

DB2 uses a sparse index scan (SIXSCAN) to access a sparse index.


Feedback