If it's not a secret, does DBW recompile using the method Ann mentioned?


-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Tuesday, June 21, 2005 4:06 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Recomputing index statistics and stored
procedures

> > No, the plans are chosen when you execute the procedure or trigger.
> >
> Are you sure of that? I thought that the plans were chosen when the
> procedure was first invoked and retained by the server until the
> database is closed.
>
> And I don't know of a way to force a recompilation except to alter the

> procedure to itself.

Hmmm... ok - not _that_ sure.

What I wanted to say was, that the plan is not stored upon creation of
the procedure (or anything like that).

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS
SQL Server Upscene Productions http://www.upscene.com



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links