Hmmm...

No real help, but a few points of note:

- The optimizer is set to rule. If you want to play with hints and such, you need to be CBO. You should be CBO anyway.

- 20 consistent gets
0 physical reads
Looks pretty good to me. What is the problem?

- I see no union

- The plan looks pretty clean to me. You might want to try Hash joins, but if the logical reads is truly 20 - you are *not* going to get better.

- Chris