what are my choices for optimizing a search that needs one key sorted ascending and one key sorted descending?
select * from mytable where key1="abc" order by key1 ASC, key2 DESC limit 0,50
Thanks
