Posted by Jean-Claude on 04/29/06 18:55

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

• Next in forum: Re: to optimize a select join
• Prev in forum: Re: My rant about unix home directories
• Thread view: to optimize a select join

[Reply to this message]