Re: Declaring Unenforced Constraints
From: Tony Andrews <andrewst_at_onetel.com>
Date: 5 Nov 2004 07:58:43 -0800
Message-ID: <1099670323.302988.198870_at_f14g2000cwb.googlegroups.com>
Date: 5 Nov 2004 07:58:43 -0800
Message-ID: <1099670323.302988.198870_at_f14g2000cwb.googlegroups.com>
Laconic2 wrote:
> So what's the point?
>
> Well, there are a lot of data architects who don't want the DBMS to
enforce
> a constraint "for performance reasons". The merits of that argument
vary
> widely from case to case, but there's some merit to it. It's
particularly
> true if the data can be guaranteed to be "cleansed" by the
transactions that
> write the data.