tag:blogger.com,1999:blog-31421954.post9157338468258379483..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : Optimizer tricksDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-31421954.post-76853370569996302602009-01-07T20:48:00.000-08:002009-01-07T20:48:00.000-08:00Hi,Good notion. However, changing your storage eng...Hi,<BR/><BR/>Good notion. <BR/>However, changing your storage engine to see what kind of indexes may sometimes not do what you would want. <BR/><BR/>Since InnoDB uses clustered index (as opposed to MyISAM, Falcon, Maria), all secondary indexes implicitly contain the primary key.<BR/><BR/>This means that when using InnoDB you can get a different execution plan than than the one you would get using MyISAM. <BR/>Please see <A HREF="http://code.openark.org/blog/mysql/two-storage-engines-different-plans-part-i" REL="nofollow">a couple</A> of <A HREF="http://code.openark.org/blog/mysql/two-storage-engines-different-plans-part-ii" REL="nofollow">posts</A> I wrote.<BR/><BR/>Regards,<BR/>Shlomi NoachAnonymousnoreply@blogger.com