Re: Join Order and performance
Do you have indexes on the columns you are using in the join condition?
If not, MySQL has no data to use for choosing the best join order and
seems to just use the same order as used in the query. I did not consider
such a case as you usually have those indexes to get those such queries done
in a reasonable time.
If MySQL gets the join order wrong although there are indexes, try to run
OPTIMIZE TABLE on the tables to get up to date statistics.
Subject
Views
Written By
Posted
8989
March 28, 2006 12:37PM
3784
March 28, 2006 03:14PM
2610
March 29, 2006 03:16PM
Re: Join Order and performance
2227
March 29, 2006 03:26PM
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.