>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
Kev,
No it won't. The SQL select is drawing all records from Table1. There is no filter criteria so no index will optimize this because there is nothing to optimize.
Regards.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao