MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Re: When create foreign key then index is auto matically generate
Posted by: Rick James
Date: April 11, 2010 05:37PM

Yes, avoid redundant indexes.

Note also, that all the fields of the PRIMARY KEY are implicitly appended to any secondary keys.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
When create foreign key then index is auto matically generate
Mayur P Vegad
April 07, 2010 09:18AM
Re: When create foreign key then index is auto matically generate
Rick James
April 11, 2010 05:37PM


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.