to optimize a select join
- From: "Jean-Claude" <pasdepub-jean-claude.monot@xxxxxxxxxx>
- Date: Sat, 29 Apr 2006 17:55:36 +0200
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
.
- Follow-Ups:
- Re: to optimize a select join
- From: Mladen Gogala
- Re: to optimize a select join
- From: NC
- Re: to optimize a select join
- Prev by Date: Re: My rant about unix home directories
- Next by Date: Re: to optimize a select join
- Previous by thread: My rant about unix home directories
- Next by thread: Re: to optimize a select join
- Index(es):