At 02:51 PM 07/02/2003 +0200, you wrote:

>And it probably uses it because you haven't got those two additional
>indexes that I suggested (one natural for your first table I normally find
>acceptable, but two is like multiplying them).
>
>Set

Created the indices and ran the query again. Here's the plan the optimizer
uses :

PLAN SORT (SORT (MERGE (SORT (S NATURAL),SORT (JOIN (C NATURAL,L INDEX
(IDX_POSTYPE))))))

There is a small improvement in execution time.


[Non-text portions of this message have been removed]