>>>>> "Steven" == Steven Roussey <sroussey@stripped>
Steven> 170 (63 with c=0) rows match 15950 and 19687 (3586 with c=0) rows match
Steven> With so many rows matching, it seems to me that it ought to use the 8 byte
Steven> index(a,c) that matches the where clause rather than the first 4 bytes of
Steven> the index(a,b).
Steven> Steven Roussey
Which MySQL version are you using?
Any change you can ftp a copy of the table to
So that I can check this ?
You can also start mysqld with
and run the query and then send the file /tmp/mysqld.trace to me!