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

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL code in constraints?

Re: PL/SQL code in constraints?

From: <sybrandb_at_yahoo.com>
Date: 30 May 2005 08:08:01 -0700
Message-ID: <1117465681.402844.230390@g49g2000cwa.googlegroups.com> 





Conducted some tests years ago, on 7.3.4, where because of third party
sw (Vision Jade) all RI was implemented by means of triggers.
Our gut-feeling was this was slower, but we couldn't convince customer.
Consequently we set up a test, with triggers migrated to the usual
declarative constraints.


This resulted in the factor 8 slower for triggers.


--
Sybrand Bakker
Senior Oracle DBA


Received on Mon May 30 2005 - 10:08:01 CDT












Original text of this message













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