MySQL Forums
Forum List  »  Memory Storage Engine

Re: INNER JOIN between MyISAM and MEMORY STORAGE ENGINE
Posted by: Ingo Strüwing
Date: June 23, 2006 11:49AM

Hi,

I'm not an expert in JOIN questions. But I guess the difference could be due to the different types of indexes. MyISAM tables use BTREE indexes, while MEMORY tables use HASH indexes by default.

You may try to create your MEMORY table with USING BTREE and see if it helps.

Another problem could be that the optimizer takes different paths due to different table types. If the above trick doesn't help, please ask again in the "Optimizer" forum.

Regards

Ingo Strüwing, Senior Software Developer - Storage Engines
MySQL AB, www.mysql.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: INNER JOIN between MyISAM and MEMORY STORAGE ENGINE
4529
June 23, 2006 11:49AM


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.