how do i find the used and unused indexes

how do i find the indexes usage of used and unused on table..

There is a script on metalink somwhere, I was searching for it yesterday but did not have any luck.

Or, you could just drop them all and what till the users tell you what they need. :D

MH

If you are using Oracle 9i, you can use Index MONITORING USAGE clause and query the v$object_usage to see that the index has been used.

HTH.

Hi

Did you try searching the forum..

anyway have a look at the link below

http://forums.dbasupport.com/forums/...0&pagenumber=2

regards
Hrishy