>>Hi all,
>>
>>Can someone advise me the performance of SQL Select 1) vs 2):
>>
>>
>>1) SELECT abc.*,xyz.dfrom,xyz.dto FROM abc LEFT JOIN xyz ;
>> ON abc.fld1=xyz.fld1 WHERE dfrom>=20060101 AND dto<=20060131
>>
>>2) SELECT abc.*,xyz.dfrom,xyz.dto FROM abc LEFT JOIN xyz ;
>> ON abc.fld1=xyz.fld1 AND dfrom>=20060101 AND dto<=20060131
>>
>>Will (1) perform faster than (2)?
>>
>>If yes, another question is how I can alter the SQL Select in the DBC if the DBC I am having has the (2) expression and I want to write a program to check for all occurences of (2) SQL Select.
>>
>>Thanks in advance.
>
>they are not equal
Thanks for the reply. Can u elaborate more?
Regards.