A composite index on (a, b) doesn't help filters on b alone
@mrnarwhal55▲ 5 net votes
Indexes are used left to right: (a, b) serves WHERE a = ? and WHERE a = ? AND b = ?, not WHERE b = ? alone.
3 COMMENTS
Key
Productive
Appreciated
Indexes are used left to right: (a, b) serves WHERE a = ? and WHERE a = ? AND b = ?, not WHERE b = ? alone.
Key
Productive
Appreciated