Home » SQL & PL/SQL » SQL & PL/SQL » Sql Tuning (Oracle 9.2.0.3)
Sql Tuning [message #409594] Tue, 23 June 2009 04:20 Go to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
If you are doing thousands of INSERTs, UPDATEs, or DELETEs, then triggers might not be the best way to handle whatever it is they are doing. Perhaps the whole thing could be packaged up into a high volume PL/SQL routine.

Why?


Thanks
Re: Sql Tuning [message #409611 is a reply to message #409594] Tue, 23 June 2009 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
42.

Regards
Michel
Re: Sql Tuning [message #409637 is a reply to message #409611] Tue, 23 June 2009 06:43 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
42???
Re: Sql Tuning [message #409638 is a reply to message #409637] Tue, 23 June 2009 06:48 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Your question is far too vague. You make a statement that looks like it is a quote from somewhere, yet you do not reference it and then simply put Why? The only valid answer is to give you the answer to Life, The universe and everything in it i.e. 42. (Do a google search on the number 42 and the hitchhiker's guide to the Galaxy

[Updated on: Wed, 24 June 2009 03:14]

Report message to a moderator

Re: Sql Tuning [message #409681 is a reply to message #409594] Tue, 23 June 2009 08:16 Go to previous messageGo to next message
prachij593
Messages: 266
Registered: May 2009
Senior Member
Quote:
If you are doing thousands of INSERTs, UPDATEs, or DELETEs, then triggers might not be the best way to handle whatever it is they are doing. Perhaps the whole thing could be packaged up into a high volume PL/SQL routine.


Could anyone help me understanding why?

The above line I have found in
Analysing problem SQL > Triggers
http://www.orafaq.com/tuningguide/

Many thanks..

[Updated on: Tue, 23 June 2009 08:18] by Moderator

Report message to a moderator

Re: Sql Tuning [message #409720 is a reply to message #409681] Tue, 23 June 2009 11:08 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Because using a shovel is better for moving large amounts of dirt than using a teaspoon.

Re: Sql Tuning [message #409817 is a reply to message #409720] Wed, 24 June 2009 03:14 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
This article should answer your question.

Ross Leishman
Previous Topic: problem in row generation
Next Topic: Cursor and exception (Merged)
Goto Forum:
  


Current Time: Sun Dec 04 10:55:58 CST 2016

Total time taken to generate the page: 0.09622 seconds