comp.lang.php archive
to optimize a select join
From: Jean-Claude <pasdepub-jean-claude.monot@wanadoo.fr>
Date: Sat Apr 29 2006 - 17:55:36 CEST
Date: Sat Apr 29 2006 - 17:55:36 CEST
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
Received on Mon May 1 03:07:26 2006