how to speed up mysql query with two order by filters

select * from mytable order by first_col desc, sec_col asc limit 1;

when using only one order by filter, the query finished rather quickly(a few seconds), but the above query took hours. would a two开发者_运维百科 column index speed this up? is there any way to speed up the query?

---

No, for now there is no solution to optimize "ORDER BY ... ASC, ... DESC". Mysql cannot create indexes with sorting order different than ASC.

ps: yes, I know it is a sorting order parameter in create index but it still doesn't work and was added to satisfy some ansi sql requirements.