MySQL Forums :: Performance :: Unexplained very bad subquery performance


Advanced Search

Re: Unexplained very bad subquery performance
Posted by: Arnaud Bertrand ()
Date: July 19, 2016 03:16AM

Of course but as I've written in my first post this is a stupid example to illustrate the problem, in the real application, it is very difficult to avoid this construction. It is possible using inner join but performance avec very bad too.

Thank you for your help.

Options: ReplyQuote


Subject Views Written By Posted
Unexplained very bad subquery performance 488 Arnaud Bertrand 07/18/2016 04:29AM
Re: Unexplained very bad subquery performance 313 Peter Brawley 07/18/2016 08:44AM
Re: Unexplained very bad subquery performance 385 Arnaud Bertrand 07/18/2016 01:06PM
Re: Unexplained very bad subquery performance 285 Peter Brawley 07/18/2016 03:30PM
Re: Unexplained very bad subquery performance 301 Arnaud Bertrand 07/19/2016 03:16AM
Re: Unexplained very bad subquery performance 292 Peter Brawley 07/19/2016 04:21AM
Re: Unexplained very bad subquery performance 288 james wang 07/20/2016 04:35AM


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.