|Subject||Re: My query plan does not use correct index|
> It seems that if i removed the "order by" clause, the query works very fast. So it must be that order by part that consumes all the performance. Any idea how to fix this?Have you tried with single field index in the requested sort order for each field in the order clause?
For this the following are missing:
and the combined can be dropped.