I have a table I'll call SomeTable that has columns called id, date, and
name along with a few others. I created two indexes for this table, one was
on id (called SomeTable_id) and the other was on id and date (called
SomeTable_id_date). When I do:
EXPLAIN SELECT * FROM SomeTable WHERE id = '0101'
it tells me:
Index Scan using SomeTable_id_date on Sometable ...
Even when I do:
EXPLAIN SELECT id FROM SomeTable WHERE id = '0101'
it still says it's using the SomeTable_id_date index. Why is it using the
multicolumn index when the date column isn't involved?
-- Jeremy [jeremy(at)wellsgaming(dot)com]