MySQL Forums :: InnoDB :: problem about second index on innodb


Advanced Search

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


Subject Views Written By Posted
problem about second index on innodb 2459 h ch 04/27/2010 12:24AM
Re: problem about second index on innodb 1333 Rick James 04/28/2010 06:44AM


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.