4 ms·
If you have a multi-column index on (number_start, number_end) Postgres will use it even if you are only filtering on number_start. An additional single column
by aeyes 5y ago
If you have a multi-column index on (number_start, number_end) Postgres will use it even if you are only filtering on number_start.
An additional single column index on number_start would be redundant.