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