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: How widespread is the use of triggers these days and how concerned about performance?....

Re: How widespread is the use of triggers these days and how concerned about performance?....

From: --CELKO-- <joe.celko_at_northface.edu>
Date: 4 Aug 2003 18:18:32 -0700
Message-ID: <a264e7ea.0308041718.5c4f3ef5@posting.google.com>


>> Am I just dreaming or that triggers are being increasingly used? <<

I would guess less used. DRI actions, DEFAULTs and CHECK() constraints do what TRIGGERs used to do in procedural code. Being predicates, these features can also send information ot the optimizers, which triggers and procedures cannot. Received on Mon Aug 04 2003 - 20:18:32 CDT

Original text of this message

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