>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
