how do i find the indexes usage of used and unused on table..
Nallamothu
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. MH
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. HTH.
-- Dilip
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
Forum Rules