Database Tuning – drop unused indexes
Posted by Dylan Wan on February 8, 2008
Index is very useful during query, especially in data warehouse. However, it adds the overhead in the storage and ETL process.
I found an excellent article about how to monitor the index usage in Oralce. You should periodically run the index monitoring process and pro-actively drop those un-used indexes.
Monitoring Index Usage in Oracle9i, by Daniel T. Liu from DBAzine.com