Hi Dmitry,

thank you for your explanation.

> 1) Outer joins cannot use ORDER plan. And you cannot force using
> ORDER even via an explicit plan. So your query should be very slow,

In my case, the speed difference is really huge, so I should consider
to run the query first and then run 25 queries to replace the left
join.

But I don't understand why the ORDER plan cannot be used in a LEFT
JOIN ? A LEFT JOIN isn't the same as an OUTER JOIN isn't it ?

Or maybe even a better solution is to insert dummy records with
PK_FIELD = 0 in such tables. I tried with the query. It's really the
"LEFT" join, that changes the plan.

cu Christian