>What is SBO column? If it's logical, I have some ideas.
SBO is logical. It also has an index attached to it.
I inheritted this code, and have converted from a VFP5 application and this is the only form with speed issues.
Thanks,
Mike
>
>>>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 if you start your query from OrdHead and then Join the rest of the tables?
>>
>>Also try to run your query without OrdHead at all, though I'm still thinking how can you then break your sums by OrdHead.SpecialOrder column.