Dylan’s BI Study Notes

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

  • About me

    I am a senior development manager working for Oracle BI Applications development. My job involves the common area, including data warehouse modeling and dimension conformance. I was involved in Oracle E-Business Suite Financial Architecture, Oracle Customer Hub, and Oracle Fusion Projects product development in the past. Disclaimer: Opinions expressed in this blog are entirely my own and do not reflect the position of Oracle.

  • Blog Stats

    • 125,389 hits

  • My Tags

« Bitmap Index - when to use it?
A good OBIEE web demo from New York City’s City Wide Performance Reporting »

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

This entry was posted on February 8, 2008 at 1:17 pm and is filed under Data Warehouse. . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

You must be logged in to post a comment.

« Bitmap Index - when to use it?
A good OBIEE web demo from New York City’s City Wide Performance Reporting »