MySQL Forums
Forum List  »  InnoDB

problem about second index on innodb
Posted by: h ch
Date: April 27, 2010 12:24AM

i see the following statement in manual

Each secondary index record also contains all the primary key fields defined for the clustered index key that are not in the secondary index.

that's mean the fields in cluster index will not be counted if they also belong to the second index?

say, i have table (c1,c2,v3,v4),if the cluster index on (c1,v3),when i create the second index on (v3,v4),the column v3 will not be stored twice??

Options: ReplyQuote

Written By
problem about second index on innodb
April 27, 2010 12:24AM

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.