--- In firebird-support@yahoogroups.com, "Martijn Tonies" wrote:

> To automatically tell which plans would change is a no-go. I cannot
> create something like that.
>
> Perhaps, storing queries and their plans for later comparison would
> be possible.
>
> It already has quite a visual PLAN Analyzer - see:
> http://www.upscene.com/documentation/dbw/oe_sqleditor.htm

I was just thinking about his current problem: "What would happen to
my system with 100s of queries if I added an index?" If those queries
were stored somewhere together (in a different table) with their
plans, then it should be easy to write a piece of code that after
creation of the index could tell which plans were different and needed
further investigation using the Plan Analyzer. Though I do not know
whether this should be part of Firebird Workbench or a separate tool.
Possibly both, a simple, clumsy freeware version written in a few
hours one afternoon and then a more sophisticated "Tonies gold"
version suitable for those who just want things to work quickly in an
intuitive manner.

Set