Re: What is the cost of integrity constraints?
From: sybrandb <sybrandb_at_gmail.com>
Date: Wed, 15 Apr 2009 02:32:30 -0700 (PDT)
Message-ID: <8b9601df-32a0-4693-8300-84c759c5cfa0_at_v19g2000yqn.googlegroups.com>
On 15 apr, 06:13, Phper <hi.steven..._at_gmail.com> wrote:
> Does the database run much slower if there are many integrity
> constraints?
Date: Wed, 15 Apr 2009 02:32:30 -0700 (PDT)
Message-ID: <8b9601df-32a0-4693-8300-84c759c5cfa0_at_v19g2000yqn.googlegroups.com>
On 15 apr, 06:13, Phper <hi.steven..._at_gmail.com> wrote:
> Does the database run much slower if there are many integrity
> constraints?
Implementing them in the database is *MUCH MORE EFFICIENT* than implementing them in the (cr)application!!!! Only consider redundant network traffic.
--- Sybrand Bakker Senior Oracle DBAReceived on Wed Apr 15 2009 - 04:32:30 CDT