to optimize a select join

Hi,

which is the faster query ? (of course, in my case the real queries are more
complex)

1/
select *
from file1 a join file2 b on b.key=a.key
where b.data=123
and b.name=’TEST’

2/
select *
from file1 a join file2 b on b.key=a.key and b.data=123
where b.name=’TEST’

Or is it the same ?
Thanks.

Jean-Claude

Leave a Reply

Your email address will not be published. Required fields are marked *