>>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
>
>What version?
VFP 9.0 no service packs... Win XP2, Windows server 2003.
VFP database