>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 McCasland
Midlothian, TX USA