Re: How to determine unused indexes

There's an article on exactly this subject at Jonathan Lewis's hosted Oracle FAQ. There's link to Jonathan's site on my site (which also happens to contain an article on the subject).

Not sure if either article mentions it, but there's a;ways the possibility of rebuilding an index into a tablespace of its own.... using utlbstat and utlestat, or using v$filestat, it's then possible to determine the reads/writes on that tablespace: lots of reads, the index is useful. Lots of writes, the table is being updated a lot, so there's a lot of index maintenance to do.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Michael Gill" <mydba_at_usa.com> wrote in message
news:fb510dcd.0203221912.606baa6f_at_posting.google.com...


> 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