Oracle Version Number will determine the answer - see Tom Kyte's website.

http://asktom.oracle.com/pls/ask/f?p=4950:8:::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:439329623515,

or

http://tinyurl.com/3e8cd

> -----Original Message-----
> thump604@(protected)
>
> Hi all!
> I'm looking for help on how to tell which indices in a
> database are used in order to derive which are unused and not
> really needed. Any help is appreciated, thanks in davance!
>
> - David
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------