MySQL Forums
Forum List  »  Newbie

Help: alternative to left join
Posted by: John Doe
Date: February 20, 2014 02:34PM

I have a huge table (~13 million records, 15 variables) indexed with multiple columns. I have another table (~100,000 records, 7 variables). Second table has two variables common with the first table . They are two big to left join, I let the left join run whole night, but it didn't complete. I can make summary tables seperately. I want to make a summary table from the second table group by a variable in the first table. Is there a fast way to do it? Please point me to some reading.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
Help: alternative to left join
February 20, 2014 02:34PM
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.