>>Hi
>>
>>This is an indexing question.
>>
>>I have 2 tables with the following statement:
>>
SELECT * FROM Table1;
>> LEFT OUTER JOIN Table2;
>> ON Table1.Field1 = Table2.Field1;
>> etc. etc.
>>
>>Right, Table2.Field1 is indexed, but Table1.Field1 is not, will it make a difference in performance if Table1.Field1 was indexed?
>
>Yes. See Sys(3054) in VFP help to see how to determine the level of optimization.
Mark
SYS(3054) reports the same whether Field1 is indexed or not!
Kev