>>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