Re: INNER JOIN between MyISAM and MEMORY STORAGE ENGINE

[Ingo Strüwing]

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