Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> To foreign key or not to foreign key

To foreign key or not to foreign key

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Tue, 14 Dec 2004 08:33:52 -0800 (PST)
Message-ID: <20041214163352.89125.qmail@web80508.mail.yahoo.com>


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
Received on Tue Dec 14 2004 - 10:37:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US