Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To foreign key or not to foreign key
I find it highly questionable for normalized tables to have 10 - 15 foreign
keys to begin with.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Fuad Arshad
Sent: Tuesday, December 14, 2004 11:34 AM
To: oracle-l_at_freelists.org
Subject: To foreign key or not to foreign key
I know this has been discussed here before and i did find a couple of jonathan lewis's old posts
The thing is we have a project where the consultants want to ensure about
10-15 foreign keys per tables to enforce parent child relationships.
I've seen locking issues beforer and was wondering if the list could put
down a some pros and cons as to going or not going with a primary foriegn
key strategy.
This is a oltp type system and sub second response is what the enpd product
requires( isnt that the description of every project these days).
The consultants want every foreign key indexed. which i think is way too
much a performance degradation since inserts are going to be major part of
the application.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 14 2004 - 12:10:31 CST
![]() |
![]() |