Re: bad Join Performance
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
Subject
Views
Written By
Posted
3734
October 31, 2011 12:21AM
Re: bad Join Performance
1089
October 31, 2011 12:41PM
937
November 01, 2011 12:12AM
1166
November 01, 2011 12:26AM
953
November 01, 2011 03:33AM
1055
November 01, 2011 08:29AM
969
November 02, 2011 08:21AM
890
November 03, 2011 12:56AM
901
November 03, 2011 12:24AM
1036
November 04, 2011 06:35AM
989
November 02, 2011 06:23AM
904
November 02, 2011 07:42AM
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.