Re: PL/SQL code in constraints?

sybrandb_at_yahoo.com wrote:
> 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

In no way critical of what you did ... if you have that suite of tests handy I would very much like to try them in 10gR1.

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)