List:General Discussion« Previous MessageNext Message »
From:Rob Wultsch Date:August 6 2008 3:57pm
Subject:Re: Picking the better query (join vs subselect)
View as plain text  
On Wed, Aug 6, 2008 at 5:18 AM, Morten Primdahl <primdahl@stripped> wrote:
> I've tried to find out if joins are preferred over subselects, but am not
> able to come to a definite conclusion. I read that correlated subselects are
> bad, and I should go for the join, but I know the id of the record in the
> outer query and can hard code that into the subselect (if that makes a
> difference).
>

Sub queries should be avoided if possible in MySQL.


-- 
Rob Wultsch
wultsch@stripped
wultsch (aim)
Thread
Picking the better query (join vs subselect)Morten Primdahl6 Aug
  • Re: Picking the better query (join vs subselect)Rob Wultsch6 Aug
    • Re: Picking the better query (join vs subselect)Waynn Lue7 Aug
      • Re: Picking the better query (join vs subselect)walter harms8 Aug