Re: Select [...] In (Select [...])
First, in MySQL, semi-joins like In(Select...) perform poorly. Use Joins instead. Second a Join on like '%Something%' can't use indexes, so it will be slow. An equi-join will perform better. If that's not possible, at least try to get rid of the leading wildcard.
Subject
Views
Written By
Posted
1685
February 02, 2015 08:12AM
Re: Select [...] In (Select [...])
1018
February 02, 2015 11:46AM
1039
February 03, 2015 11:12AM
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.