Expand description
Count-only integer anti-join.
This operator implements the common integrity-check shape
COUNT(*) FROM outer LEFT JOIN inner ... WHERE inner.not_null IS NULL
without constructing joined rows. The outer side remains a narrow stream.
Integer primary keys use bounded visibility probes; other integer keys use
a compact key set built from an exact one-column scan of the inner side.