List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 25 2003 7:52pm
Subject:Re: Optimize Question
View as plain text  
In the last episode (Aug 25), Patrick Crowley said:
> I'm running 3.23.52 locally, but I just noticed my production server
> is running 4.0.12.
> 
> Given the complexity of this query, should I use subqueries instead
> of joins? Would that make any difference?

The subquery equivalent to your joins should be processed exactly the
same way (barring optimizer bugs).  You would have to use 4.1.0 to get
subqueries anyway.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Optimize QuestionPatrick Crowley25 Aug
  • Re: Optimize QuestionDan Nelson25 Aug
    • Re: Optimize QuestionPatrick Crowley25 Aug
      • Re: Optimize QuestionDan Nelson25 Aug
        • Re: Optimize QuestionPatrick Crowley25 Aug
          • Re: Optimize QuestionDan Nelson25 Aug