Re: [firebird-support] Plan evaluation in stored procedures

2015-08-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Aug 10, 2015, at 8:15 AM, Aldo Caruso aldo.car...@argencasas.com [firebird-support] firebird-support@yahoogroups.com wrote: does it mean that if the database is shut down periodically the stored procedure plans would be recalculated ? Shutting the database periodically solves

RE: [firebird-support] Plan evaluation in stored procedures

2015-08-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Aldo, My question is: does the optimizer evaluates the plan for the query each time the stored procedure is excecuted or is it evaluated only once, when the stored procedure is compiled to BLR. In the latter case it would be a dissadvantage because as time passes, table cardinality