Re: need trigger suggestions (works but is SLOW)

"Glen S" <whoknows_at_no_spam.com> wrote in message news:0y9Md.98189$Qb.44072_at_edtnps89...
>I created a trigger on an app that will update a column on a newly inserted
>row if another column's value(in the new row) matches some values in other
>tables.

I've spent approx 30s on this so may be wrong but doesn't this boil down to

check that col2 exists in col f in some other table - check constraints should do this.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com