Skip navigation links

MySQL Forums :: Performance :: bad Join Performance


Advanced Search

Re: bad Join Performance
Posted by: Jorgen Loland ()
Date: October 31, 2011 12:41PM

Hi Leo,

Please provide the output of EXPLAIN for your query (enclosed in [ code] [ /code] tags). Also remove the USE INDEX hints. By using these hints you take on some of the responsibilities of the optimizer, so you should only use them if you are not happy with the choices it makes.

Hope this helps,
Jørgen Løland
Software Engineer, MySQL, Oracle
jorgenloland.blogspot.com

Options: Reply•Quote


Subject Views Written By Posted
bad Join Performance 2231 leo . 10/31/2011 12:21AM
Re: bad Join Performance 526 Jorgen Loland 10/31/2011 12:41PM
sry, double post 482 leo mueller 11/01/2011 12:12AM
sry, double post 654 leo mueller 11/01/2011 12:26AM
Re: bad Join Performance 447 leo mueller 11/01/2011 03:33AM
Re: bad Join Performance 463 Jorgen Loland 11/01/2011 08:29AM
Re: bad Join Performance 509 leo mueller 11/02/2011 08:21AM
Re: bad Join Performance 397 Jorgen Loland 11/03/2011 12:56AM
Re: bad Join Performance 461 leo mueller 11/03/2011 12:24AM
Re: bad Join Performance 534 Jorgen Loland 11/04/2011 06:35AM
Re: bad Join Performance 458 Rick James 11/02/2011 06:23AM
Re: bad Join Performance 458 leo mueller 11/02/2011 07:42AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.