SQL: a composite index on (a, b) does nothing for a query on b alone

A B-tree is sorted by the first column, then the second within it. Values of b are scattered across the whole index, so filtering on b alone cannot seek - the planner ignores the index and scans the table.

Full code & output

This topic is available to PRO members.