MySQL Forums
Forum List  »  Newbie

Re: Help: alternative to left join
Posted by: Peter Brawley
Date: February 20, 2014 03:52PM

First thing I would do if find out why the left join takes all night. Run EXPLAIN EXTENDED on the query and post the result in human-readable form eg inside BBCode code tags. Also post the result of Show Create Table for each table.

Options: ReplyQuote


Subject
Written By
Posted
February 20, 2014 02:34PM
Re: Help: alternative to left join
February 20, 2014 03:52PM
February 20, 2014 04:38PM
February 21, 2014 02:06PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.