----- Original Message ----- 
From: "Florin Andrei" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 05, 2001 9:08 PM
Subject: [rlug] optimizare MySQL


> 
> O intrebare pentru cei care au experienta cu optimizarea MySQL...
> 
> Vreau sa rulez ceva de genul:
> 
> 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 ?

Marius

---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to 
unsubscribe from this list.

Raspunde prin e-mail lui