MySQL Forums
Forum List  »  Database Design & Data Modelling

Advanced Search
New Topic

Is Using Multiple Composite Primary key a Good Design Practice?
Posted by: Abhishek Alney
Date: August 07, 2015 04:48AM

Hello,

I would like to know if using Multiple column Primary key or Composite Primary key has any effect on database performance. We are using the latest MySQL 5.6.25 source version(innodb tables) with Java Platform and angular JS.

We are building a reporting database and it will have huge amounts of data. 90% of our tables have Composite Primary key and Composite Primary Foreign Key. Minimum 2 to a Maximum of 7-8 combination of Composite Primary key and Composite Primary Foreign key.


Is this a good design practice and what effect it will/may have in future on database performance.

Kindly help me in this regard.

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


Subject
Written By
Posted
Is Using Multiple Composite Primary key a Good Design Practice?
Abhishek Alney
August 07, 2015 04:48AM
Re: Is Using Multiple Composite Primary key a Good Design Practice?
Rick James
August 07, 2015 10:52AM


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.