If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to find unused index in 8.1.7.4

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.