Ryan, 'can be faster' is rarely inaccurate. It all depends.
SF >----- ------- Original Message ------- ----- >From: <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 29 Oct 2003 06:49:33 > >the only book out there that is any good is High >Performance Tuning by Guy Harrison. Ignore the part >where he says that a cursor with an update in the >loop can be faster than using an update with where >exists. That is inaccurate. > >the rest is solid. > >unforunately its not that simple. How you tune >depends on the type of system you have. If your in >an OLTP system with alot of concurrency, you tune >heavily for Logical I/Os even if the query takes >longer to run in isolation. If your doing batch >queries, then you tune more for response time and >less for logical I/Os. > >its just not that simple. >> >> From: "Ranganath K" <[EMAIL PROTECTED]> >> Date: 2003/10/29 Wed AM 09:24:25 EST >> To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >> Subject: SQL and PL/SQL tuning template document >required urgently >> >> Hi there, >> >> Does any body have a template for proactive >and reactive query tuning which can be used as a >guideline/report while tuning simple, medium >complex and complex SQL queries and PL/SQL stored >procedures? If so, can you please forward the same >to me please? If not, can anybody suggest as to >how to go about doing one? Any help in this regard >is very much appreciated. >> >> Thanks and Regards, >> >> Ranganath >> -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).