Home » SQL & PL/SQL » SQL & PL/SQL » Peformance when using rowlevel trigger and column trigger
Peformance when using rowlevel trigger and column trigger [message #223467] Fri, 09 March 2007 00:45 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

What would be the performace if we use column level trigger and rowlevel trigger.
In terms of performance which would be a better to use

Thanks
Re: Peformance when using rowlevel trigger and column trigger [message #223494 is a reply to message #223467] Fri, 09 March 2007 03:15 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I think you may be getting a bit confused with your syntax.

Triggers don't come in ROW or COLUMN flavours, they come in ROW or STATEMENT. (plus, of course, BEFORE/AFTER/INSTEAD and INSERT/UPDATE/DELETE)

YOu can add conditions to a row level trigger so that it will only fire if a specific condition is met (and that condition is frequently that a given column value is changed).

So, if what you're asking is:
What would provide the lower impact on performance - A Row Level trigger, or a Row level trigger with a condition attached specifying that a given column had to have changed before the trigger fired
then the answer would almost always be 'The trigger with the condition'
Re: Peformance when using rowlevel trigger and column trigger [message #223700 is a reply to message #223467] Sat, 10 March 2007 09:22 Go to previous message
William Robertson
Messages: 1640
Registered: August 2003
Location: London, UK
Senior Member
Or if possible, avoid triggers entirely.
http://tkyte.blogspot.com/2007/03/dreaded-others-then-null-strikes-again.html
Previous Topic: Granting ownership on any object to other user
Next Topic: Error PLS-00201:SYS_REFCURSOR must be declared
Goto Forum:
  


Current Time: Fri Dec 09 02:01:26 CST 2016

Total time taken to generate the page: 0.05429 seconds