Re: ADO recordsets using a stored procedure

From: keith boulton <boulke_at_globalnet.co.uk>
Date: Fri, 05 Mar 1999 15:54:11 GMT
Message-ID: <36dffbca.2533042@read.news.global.net.uk>

On Wed, 24 Feb 1999 23:31:41 -0500, "Eric L. Ma" <mlq_at_ndi.net> wrote:

>There are solid reasons to use stored procedures to return recordsets from
>Oracle, and performance enhancement is one of the top reasons.

Replacing a sql statement with a stored procedure will not (generally) improve performance in Oracle. The mechanism used for parsing and in particular for re-using parse trees and access paths is completely different in Oracle to sqlsqerver. Received on Fri Mar 05 1999 - 09:54:11 CST