Skip Scan

A B-tree index optimization added in PostgreSQL 18 that efficiently handles queries where the leading index column has low cardinality. Instead of scanning the entire index, the executor skips to the next distinct value of the leading column. Eliminates the need for certain multi-column indexes.