Hello Petras,
>The VFP table resides on a SCO Unix system and is shared on the network via Samba. I have turned on SQL Showplan: SYS(3054,1) and this shows that full Rushmore optimisation has been used in the VFP program. Curiously, the VFP program is only slower on
You should use sys(3054,11) to see how the query processed by VFP. I bet that there
is partial optimization level for joins.
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer