Re: thread with the same subject.

From: DM <amd_at_spam_spam.idirect.com>
Date: Wed, 28 Jul 1999 14:05:54 -0400
Message-ID: <379F4682.F48B153F@spam_spam.idirect.com>

Sorry,
I didn't nottice the thread with the same subject. DM

DM wrote:

> Hello everybody,
> I wanted to speed up a sql statement execution so I embedded it in a
> stored procedure and the result set is passed through a ref cursor to
> the client. I got no speed improvement. Does anyone know more about
> this? I mean, the general wisdom is that a stored procedure will give
> you a 20% increase in speed upfront because the sql is already parsed,
> the datapath set up. It seems that it's not the case. The sql is a join
> and outer join of 4 tables with a parameter and it retrieves 899 rows.
> Thanks,
> Max Mera
Received on Wed Jul 28 1999 - 13:05:54 CDT