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.
I remember when this place was cool.
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.
Did you try searching the forum..
anyway have a look at the link below