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!

Atomic Primary Key or Composite ? Which approach is better ?

ZAFeb 24 2003 — edited Feb 24 2003

Hi all,

I have a table that has its composite primary key (infact foriegn keys of other tables make pk in this table).
But due to large project complexity, i just want to have an atomic primary key, so that i could use a sequence for it, instead of using N foreign keys from other tables. And furthermore, a single column primary key can be easily accessed as foreign key as compared to N columns primary key.
Is it a good approach in general ?
My personal view has certain reservations regarding the atomic primary key in such case. It could lead to a weak database design.
Any suggestion ?

Thanx
Zaaf.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2003
Added on Feb 24 2003
1 comment
842 views