Can I improve the "ORDER BY" by adding an index on fld_date.
SELECT * FROM t1 WHERE fld1='XXX' fld2='XXX' ORDER BY fld_date;
The query uses the index of (fld1,fld2 - combined index) in the where clause. As the ORDER BY does not match the index exactly, If I do add an index with fld_date will it be useful in improving the ORDER BY fld_date performance. ?