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

**URL:** <https://forums.percona.com/t/to-mysql-guru-is-it-possible-to-index-on-select-where-a-and-b-and-c-in-order-by-d/1086>\
**Category:** Other MySQL® Questions\
**Created:** [February 15, 2009, 10:32am UTC](https://forums.percona.com/t/to-mysql-guru-is-it-possible-to-index-on-select-where-a-and-b-and-c-in-order-by-d/1086 "2009-02-15T10:32:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![fwang](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@fwang](https://forums.percona.com/u/fwang)\
**Post date:** [February 15, 2009, 10:32am UTC](https://forums.percona.com/t/to-mysql-guru-is-it-possible-to-index-on-select-where-a-and-b-and-c-in-order-by-d/1086/1 "2009-02-15T10:32:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![MarkRose](https://avatars.discourse-cdn.com/v4/letter/m/85f322/32.png) [@MarkRose](https://forums.percona.com/u/MarkRose)\
**Post date:** [March 21, 2009, 6:25pm UTC](https://forums.percona.com/t/to-mysql-guru-is-it-possible-to-index-on-select-where-a-and-b-and-c-in-order-by-d/1086/2 "2009-03-21T18:25:58Z")

</div>

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?