Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

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

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s