-
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.
regards
anandkl
anandkl
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|