Re: How to determine unused indexes

Michael Gill wrote:
>
> Given that I have numerous indexes, how can I determine which ones are
> NOT used. I could check each query with explain plan, but is there an
> easier method? Is there some v$ table that counts hits on an index?
>
> Thanks

If you're using 9i, there's a new feature called index monitoring which you may find useful. See the article "Using Oracle9i to Clean Up Indexes" in the last issue of Oracle Magazine:

http://www.oracle.com/oramag/oracle/02-jan/index.html?o12o9index.html

Regards,
Sean Received on Fri Mar 22 2002 - 23:25:54 CST