> >>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
Server
Upscene Productions
http://www.upscene.com