MySQL Forums
Forum List  »  Optimizer & Parser

Re: optimize select query
Posted by: Rick James
Date: December 31, 2010 08:22PM

Multiple, nested, groupwise max?? Ouch.

Study the examples in the links in here
http://forums.mysql.com/read.php?10,400440,401023
The reformulate the subqueries.

Perhaps we should first focus on
      and  bo.first_value = 
      ( SELECT  max(book1.first_value)
            from  bookmakers book1
            where  book1.event_id = je.id
              and  book1.insert_date = 
              ( SELECT  max(insert_date)
                    from  bookmakers
                    where  event_id = je.id
                      and  bookmaker_id = book1.bookmaker_id))
until you can avoid those subqueries.

Options: ReplyQuote


Subject
Views
Written By
Posted
3112
December 30, 2010 10:59AM
Re: optimize select query
1338
December 31, 2010 08:22PM
1514
January 03, 2011 01:02PM
1450
January 04, 2011 04:07AM
1656
January 06, 2011 09:37PM


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.