Hi Friends,
I am using oracle 8.1.7.4 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.

regards
anandkl