>Trying you suggestion Naomi, reveals the following sys(3054,11)
>

>
>Rushmore optimization level for table ordsize: none
>Rushmore optimization level for table ordprod: none
>Using index tag Sbo to rushmore optimize table ordhead
>Rushmore optimization level for table ordhead: partial
>Joining table ordprod and table ordhead using index tag Orderid
>Joining intermediate result and table ordsize using index tag Orderprodi
>Rushmore optimization level for table ordsize: none
>Rushmore optimization level for table ordprod: none
>Using index tag Sbo to rushmore optimize table ordhead
>Rushmore optimization level for table ordhead: partial
>Joining table ordprod and table ordhead using index tag Orderid
>Joining intermediate result and table ordsize using index tag Orderprodi
>

>
>IS this a better result than previous one. Also, why would this be better, besides the removal of the cartesian product of the original one.
>
>Thnaks,
>Mike

Yes, it seems better. You eliminated the cartesian product. You have partial optimization since you're running with SET DELETED ON obviously.

You may also try Borislav's idea.

Finally, try for now removing OrdHead at all from your query.