Subject Re: My query plan does not use correct index
Author chris.waldmann
> 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?
> Regards,
> Reynaldi
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:

Table A
(POSTDATE) Descending
(OBJID) Descending

Table B
(CALCTYP) Descending

and the combined can be dropped.