| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Concerns with Foreign Key Integrity Constraints?
On Tue, 21 Sep 1999 16:18:28 -0400, Andy Philpotts
<AndyPhi_at_reciprocal.com> wrote:
>Is there any reason why we should not do
>this? Performance is one issue that springs to mind...
Performance is the biggest issue, but if you can afford the hit, then I'd do it.
One other issue to watch out for though, is that your apps might briefly allow integrity to be violated. For example, you might have an application that inserts the order-detail records before it inserts the parent order record. That's a simplistic example, but you get the idea. If you define foreign key constraints, your app could suddenly fail because it isn't doing things in the correct order. You'll have to test on a test system before change things on the live system.
There may be other issues but those are the two that I've had experience with.
Jonathan
 |
 |