MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]
Posted by: KimSeong Loh
Date: July 05, 2007 01:14AM

Comparing the EXPALIN result, the difference is that InnoDB has the "using index" which does not need to read the data row, where MyISAM needs to read the data row using the pointer.

Even though you do not use IDX in the WHERE, you use it in the SELECT columns, so the value of IDX is required. InnoDB can get the value from the index, while MyISAM needs to use the pointer to read the data.

Options: ReplyQuote




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.