I have this problem as well, where the index does not cover everything i need. However, i’m able to get what I want by doing the following:
select * from db USE KEYS (
select raw meta().id from db
where param1=x
order by param2 desc
limit 10
)
This will force the cover query and then do a fetch on the matched keys, where as doing a straight select will force the fetch which slows everything down.