If i have a query
SELECT A,B,C,D,E,F,G FROM tbl WHERE A=1 AND B=2 AND C IN (3,4,5) ORDER BY D
(A,B,C,D,E,F,G are all integers)
Is it possible to create an index something like (A,B,C,D) so that when doing explain, mysql looks up MIN number of rows and DOES NOT need to do a filesort???
Thanks in advance