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@xxxxxxxxxxx > > 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------