Re: index never used

How about rebuilding them, a few at a time, into their own tablespace (complete with its own data file(s) of course) and then monitoring the physical reads on those data files? If you get lots of physical reads, the indexes are useful. If not, they're not. Ignore the physical writes... naturally, if the table is updated, you expect the indexes to be updated, too. And yes, updating the index causes reads, too. So what you are after is a huge disproportion between writes and reads.

Alternatively, upgrade to 9i and use the new index monitoring feature.

Regards
HJR

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


"franz mueller" <franz.mueller_at_orbis.de> wrote in message
news:7a80b509.0202060236.18402eb8_at_posting.google.com...


> Hi,

>

> I have a DB, that has a huge amount of indices. I am would bet that

> 80% of them have been added by people not knowing what they are doing,

> and therefore are never used. How can I monitor those indices. I use

> 8.x

>

> Thank you

> Franz