MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Select with IN clause hangs, but not with JOIN
Posted by: Peter Brawley
Date: May 01, 2014 12:07PM

Yes, semijoins are best avoided, in general subqueries run better in the FROM clause than elsewhere, see ...

"The unbearable slowness of IN()" at http://www.artfulsoftware.com/queries.php

http://www.xaprb.com/blog/2006/04/30/how-to-optimize-subqueries-and-joins-in-mysql

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


Subject
Views
Written By
Posted
Select with IN clause hangs, but not with JOIN
1297
Daniel Coello
April 30, 2014 02:35PM
Re: Select with IN clause hangs, but not with JOIN
771
Peter Brawley
May 01, 2014 09:57AM
Re: Select with IN clause hangs, but not with JOIN
870
Daniel Coello
May 01, 2014 11:26AM
Re: Select with IN clause hangs, but not with JOIN
740
Peter Brawley
May 01, 2014 12:07PM
Re: Select with IN clause hangs, but not with JOIN
913
Daniel Coello
May 01, 2014 04:52PM


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.