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 t1 LEFT JOIN t2 ON t2.c_ID=t1.ID WHERE .... But this is very slow... (10 minutes) :((( Why?? Somebody can help me? Tnx!! Best Regards! Zoltán Gyurasits
