How to find unused index in 220.127.116.11
I am using oracle 18.104.22.168 on sun solaris,
We have a table which has quite a few indexes and i wanted to know which index is being used and wanted to drop the unused indexes.
can u please let me know how i can do this.
I know i can query v$sqlarea to find out all the query running on this table and do an explain plan on all those queries and find the unused index and drop them. But i would like to know if there is any other simple way.
Click Here to Expand Forum to Full Width