Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Primary & Foreign key constraints
Rufus,
if you try to enforce RI at the app level .. u are looking in the face of increased IO hits as you try to manually force RI rules.. may also lead to funny situations (mutating/constraining) as you start playing with triggers trying to accomplish the same. thats all my brain cells allow me to write at this point :-((
deepAk
-----Original Message-----
From: Rufus Chinnam [mailto:rufus.chinnam_at_emirates.com]
Sent: Monday, May 22, 2000 10:44 PM
To: Multiple recipients of list ORACLE-L
Subject: Primary & Foreign key constraints
Hi Guru's,
Will any one tell, if there is any specific advantage if we don't have primary & foreign key constraints at database level. In one of our major applications I have seen, they do not have primary & foreign key constraints defined at database level, but handled at the front end level. Can anyone tell what could be the merits if any ?
TIA,
Rufus.
-- Author: Rufus Chinnam INET: rufus.chinnam_at_emirates.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue May 23 2000 - 00:13:46 CDT
![]() |
![]() |