----- Original Message -----
From: "Marius Stan" <[EMAIL PROTECTED]>
> > SELECT tbl1.col1, tbl2.col1 FROM tbl1, tbl2 WHERE \
> > tbl1.col2 = tbl2.col2 AND tbl1.col3 = '666';
> Daca folosesti:
> SELECT tbl1.col1, tbl2.col1 FROM tbl1
> LEFT JOIN tbl2 on tbl1.col2 = tbl2.col2
> WHERE tbl1.col3 = '666',
>
> iese mai repede ?
Experienta mea la MySQL e aproximativ nula, in schimb la SQL in general ma
mai pricep.
LEFT JOIN n-are cum sa fie mai rapid decat query-ul initial; pentru
non-believers:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Optimisation
.html#LEFT_JOIN_optimisation
Mihai
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
