Re: RE: Useful Oracle books

From: <Jared.Still_at_radisys.com>
Date: Thu, 27 May 2004 12:10:13 -0700
Message-ID: <OF1C179BB0.3FD5FAA1-ON88256EA1.00691196-88256EA1.00694DE8@radisys.com>

oracle-l-bounce_at_freelists.org wrote on 05/27/2004 11:52:39 AM:
> I tested the 'where current of' statement extensively last year and
> it was always took me about twice as long to do an
> update(particularly a batch update) than with straight sql. Can
> someone show me a repeatable case where you want to use pl/sql over
> sql? It's all over asktom that you should use sql if at all possible.
>
> Until I Actually see some repeatable cases, in my opinion pl/sql is
> always slower than sql.
>

It isn't currently in my best interest to build a test case for this. ie. I have too much to do.

I would have to examine the section of Tom's book that mentions this to comment further.

In my case, 'where current' of was very efficient, as doing the job in straight SQL would have required many SQL statements, as oppposed to some procedural code and two cursors.

If you can do it in one SQL statement, yeah, it's a no-brainer.

Other than that may require some testing.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 27 2004 - 14:07:29 CDT