Index merge optimization with joined tables?
Hello,
Is MySQL 5.0's Index merge optimization is also available to multiple
table joins? When I do explain on 3 table joins, only one key per table
is used :
SELECT R.* FROM L, M, R
WHERE
L.key1 = 1
AND L.key2 = M.key2
AND M.key1 = R.key1
R table has 10 rows
M table has 24 million rows
L table has 9 million rows
Explain plan only shows ref & eq_ref type optimization is being used. M
table has 2 key fields used in the joins and only one is used. Tables
are InnoDB, total size of the tables is around 9G. I'm using MySQL max
5.0.16
Any suggestions?
Thank you
Kayra Otaner
Subject
Views
Written By
Posted
Index merge optimization with joined tables?
3601
December 01, 2005 11:39AM
2359
December 07, 2005 08:21AM
2355
December 07, 2005 05:37PM
2202
December 21, 2005 10:54PM
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.