I've got sp2 installed. Is there an additional hotfix? In this case there are no indexes. Just something VFP is doing internally. For some reason in 8, it is setting up a temp index.
>>Checking sys(3054,11) :
>>VFP 8.0 - Shows no optimization but uses a temp index.
>>VFP 9.0 - Shows no optimization but shows (Cartesian product)
>>
>>I found this thread. Seems to be the same issue I'm seeing.
>>
http://www.dbmonster.com/Uwe/Forum.aspx/foxpro/5717/VFP9-SQL-statement-problem>>
>>I'm still researching.
>>
>Just in case - are you using VFP9 SP2 latest hotfix? Do you have indexes with variable length? If yes, then it's another problem, which you better fix ASAP.