Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Composite Primary Keys or single primary key

450482Sep 8 2008 — edited Sep 8 2008
Hi
I am working on a project where I see that in most of the tables composite primary keys are maintained. My question is isnt it easier to have a single primary key in place of multiple - When it comes to querying those tables, maintaining etc? I am trying to understand the model by querying different tables but am realizing that these multiple PK are just making it difficult to understand the actual purpose, relationship etc.

What would you suggest? I am still in the early stages and things can be changed. i am worried about getting unexpected surprizes when I move to Qa environment.
Any insights greatly appreciated.
Thx!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2008
Added on Sep 8 2008
4 comments
701 views