how do i find the indexes usage of used and unused on table..
Printable View
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