Re: Limitation of SQL when making LEFT JOIN

[Juan C. P. Garrido]

Keith C. Ivey wrote:

On 21 Nov 2002, at 8:46, Juan C. P. Garrido wrote:

When I make the LEFT JOIN between the two tables, it takes a long time,
and it seems that the machine is crashed , because everything I try to make
in the machine is extremely slow, so I have to reset it manually.

Do you have indexes on the columns you're using for the join? Can you show the output of EXPLAIN on your query?

Thanks you for your response. Really one of the tables was without index and for this reason the
query with LEFT JOIN was so slow.

Thanks,

Juan




---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php