What SYS(3054,11) says about JOINs optimization? Which VFP version are you using?

Joining table ordhead and table ordprod (Cartesian product)
Joining intermediate result and table ordsize (Cartesian product)
Rushmore optimization level for table ordsize: none
Rushmore optimization level for table ordprod: none
Rushmore optimization level for table ordhead: none
Joining table ordhead and table ordprod using index tag Orderid
Joining intermediate result and table ordsize using index tag Orderprodi

That is the output from sys(3054,11)

How do I interpret this to speed up the query?

Thanks,
Mike