Subject Re: [IB-Architect] new idea/proposition.
Author Vince Duggan
> With this cumulative data, the engine would either (a) create indexes
> for you silently, or (b) keep its hands off the metadata, and instead
> just produce an advisory report (including a SQL script of CREATE INDEX
> statements) when asked. The behavior could be configurable per server
> or per database.

I think something along these lines is a definite requirement. A couple
of other things fit into this as well:

1) Profiling your database: Seeing which statements run most often, and
which ones are slowest,

2) A utility which displays what statements are currently running, with
a facility to terminate a particular statement.


Vince Duggan
Synectics Software
Inprise C/S Business Partner
South Africa