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.
DB2 uses a sparse index scan (SIXSCAN) to access a sparse index.