How to find unused index in 18.104.22.168
I am using oracle 22.214.171.124 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