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?

Thanks
Kev