MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: I need to better understand how to use self joins
Posted by: Rick James
Date: April 17, 2012 09:31PM

Once you have split the parts into two separate columns, you can index the appropriate column and do a LEFT JOIN. _Much_ faster than IN(SELECT...).

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
I need to better understand how to use self joins
Shawn Taylor
April 16, 2012 08:44AM
Re: I need to better understand how to use self joins
laptop alias
April 16, 2012 10:31AM
Re: I need to better understand how to use self joins
Rick James
April 17, 2012 09:31PM
Re: I need to better understand how to use self joins
Shawn Taylor
April 24, 2012 01:05PM
Re: I need to better understand how to use self joins
Peter Brawley
April 24, 2012 03:36PM


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.