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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers : Performance Trade Off?

Re: Triggers : Performance Trade Off?

From: Mark Styles <lambic_at_msn.com>
Date: 1997/09/12
Message-ID: <34194C68.2722@msn.com>#1/1 







Jcen wrote:


> Would it be faster to have the code in a stored procedure than in a

> separate trigger procedures?




I'm not sure if it is still the case in the latest Oracle versions, but
trigger code used to be stored uncompiled, whereas stored procedures are
stored compiled, which means stored procedures are faster. 



It is common practice to have skeletal triggers which call stored
procedures holding the bulk of the code.
Received on Fri Sep 12 1997 - 00:00:00 CDT












Original text of this message













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