MySQL Forums
Forum List  »  Optimizer & Parser

Index merge optimization with joined tables?
Posted by: Kayra Otaner
Date: December 01, 2005 11:39AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Index merge optimization with joined tables?
3601
December 01, 2005 11:39AM


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.