Printable View
Hi
We are in process on restructuring/reorganizing the database and find out that DBA before has created many indexes on tables and lot of them are not needed and we want to drop them.
How do we find index that are created on tables and yet are not used ?
Thanks
What version?
In 8i, the standard response is "use catio.sql", although I have had marginal results with catio. You can also periodically sample v$object_usage, but this method is only a sampling and not a complete view of what is being used over time. In short, there's no "Easy" way to do it in 8i.
In 9i, you can use index monitoring. See http://otn.oracle.com/docs/products/...8a.htm#2113145 for details.
Jeff
Thank you for the prompt response. In that case can you tell me how to get the list of duplicate index or table
Thanks
Look at dba_ind_columns
This brings to mind:
"Don't ever take a fence down until you know the reason why it was put up."
-- Gilbert Keith Chesterton (1874-1936)