When a stored procedure is first executed, the execution plan for each
statement in it is saved until the database is restarted or the last
connection closed.
When an SQL statement is executed, the plan is not saved, although the
statement may be cached on the client side (e.g. Jaybird's statement
pooling).

-----Original Message-----
From: Firebird-Architect@yahoogroups.com
[mailto:Firebird-Architect@yahoogroups.com] On Behalf Of
women_lover_best
Sent: Thursday, July 14, 2005 1:44 AM
To: Firebird-Architect@yahoogroups.com
Subject: [Firebird-Architect] Re: Stored procedures vs Dynamic SQl

Hi,

What I meant was.. SQL server 2000...saves execution plan of stored
procedures as well as Dynamic SQL.. what does Firebird do? We r
developing an application which uses client(smart in .net) and server in
.net, and Firebird as database(WAN netwrok using optical fibres).I would
like to go for Dynamic SQL(using LLBgen like product)..as I feel
maintaing stored procedures is a painful job thanks



--- In Firebird-Architect@yahoogroups.com, "Leyne, Sean" <Sean@B...>
wrote:

>
> > does firebird saves execution plan both for Sp and dynamic

SQL's..is

> > there a performance difference?
>
> Please clarify your definition of 'saves'.
>
>
> Sean

Yahoo! Groups Links