[TO MYSQL GURU] Is it possible to index on SELECT ... WHERE A=.. AND B=.. AND C IN (...) ORDER BY D

MySQL & MariaDB Other MySQL® Questions
1

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

2

Have you tried

SELECT A,B,C,D,E,F,GFROM ( SELECT A,B,C,D,E,F,G FROM tbl WHERE C in (3,4,5) )WHERE A=1 AND B=2ORDER BY D

with indexes on C and (A,B,D) separately?