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 - 11:29:46 CDT
