|Subject||Re: [IB-Architect] new idea/proposition.|
>I think something along these lines is a definite requirement. A couple
> 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.
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.
Inprise C/S Business Partner