At 11:49 PM 07/18/2000 -0700, you wrote:

>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.

In a recently published Oracle magazine it tells you how you can ask
Oracle to list the queries that take the longest, cause the most records
scanned etc.. It seems like a nice thing.

:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/ Americas Background
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered
the risks of a bad hire.