Subject Re: [Firebird-Architect] FW: Recomputing index statistics and stored procedures
Author Martijn Tonies
> >>If the statistics for an index were to be recalculated, then it would
> >>seem appropriate to 'mark' the SPs which reference the table as 'dirty'
> >>to have the system recalculate the plan at the next appropriate
> >>invocation.
> >
> > Sounds fairly easy.
> >
> How would you do it in classic?

Yet another reason I'm starting to loathe classic :-)

How is classic currently handling metadata changes, any changes?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions