Re: MySQL not using indexes
Does using an explicit join help any?
EXPLAIN EXTENDED
SELECT *
FROM territory_borders_finished tb
JOIN territories_finished te ON
te.te_game_number = tb.tb_game_number AND
tb.tb_border = te.te_code
WHERE tb.tb_game_number = 379085
Shawn
Subject
Views
Written By
Posted
3604
February 23, 2011 01:31AM
Re: MySQL not using indexes
1209
February 23, 2011 08:16AM
1079
February 23, 2011 09:58AM
1177
February 24, 2011 09:26AM
1209
February 24, 2011 12:25PM
1454
February 24, 2011 03:36PM
1123
February 24, 2011 06:57PM
1555
February 24, 2011 08:49PM
1042
February 25, 2011 12:52AM
1027
February 25, 2011 07:44AM
925
February 25, 2011 11:40AM
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.