MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizer Decisions change with Storage Engine [MyISAM, InnoDB]
Posted by: Drei Bit
Date: July 04, 2007 10:49AM

Hello,

yes I missed the Index. (I edited the post, to repair that)

Your explanation is not quite clear to me.
So the index c_ix_dummy_id of InnoDB Table C contains the triple (dummy, id, idx) the difference to MyISAM basically is that b_ix_dummy_id contains the triple (dummy, id, row_pointer*). Still both indexes contain the same data for the first two columns? So it should not be necessary even for the MyISAM table to follow the pointer and seek the complete row. Reading the corresponding nodes in the B-Tree should be sufficient.

what am I missing here?

greetings
3bit

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.