quot;Gyurasits Zoltán" <[EMAIL PROTECTED]>;
Sent: Monday, June 13, 2005 10:21 AM
Subject: Re: Optimises LEFT JOIN
Hi zoltan
if you know difference between inner join and left join, you can conclude
than
maybe there are a lot of rows in table1 which do not verify you join
condition.
Message -
From: "Jigal van Hemert" <[EMAIL PROTECTED]>
To: "Gyurasits Zoltán" <[EMAIL PROTECTED]>;
Sent: Monday, June 13, 2005 10:01 AM
Subject: Re: Optimises LEFT JOIN
From: "Gyurasits Zoltán"
I have a speed problem with LEFT JOIN condition.
(...)
Hi zoltan
if you know difference between inner join and left join, you can conclude than
maybe there are a lot of rows in table1 which do not verify you join condition.
This example show you that the result is different and and add'in where clause
if you want to transform the left join result like
From: "Gyurasits Zoltán"
> I have a speed problem with LEFT JOIN condition.
(...)
> Why?? Somebody can help me? Tnx!!
You will probably get a lot more useful response if you include the table
structure, the complete query/queries and the output of EXPLAIN for each
query (just put EXPLAIN in fron
