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
Hello All!
I have a speed problem with LEFT JOIN condition.
SELECT *
FROM t1
INNER JOIN t2 ON t2.c_ID=t1.ID
WHERE
The table2 row count is high. (100 000 records)
This is correct and FAST (1-2 sec), but not good for me. Because I need all
record from table1.
I use this...
SELECT *
FROM
