Tag Archives: unused indexes

Are my indexes used – Part III

Last month, I wrote an article that identifies indexes that are not used in DB2 UDB. Well,  IBM has made it easier in DB2 V9.7.  They now have a  monitor routine called MON_GET_INDEX that can help identify the indexes that … Continue reading

Posted in database, db2 | Tagged , , , , , , | Leave a comment

Are my indexes used ?

Often I wonder out of all those 100s of indexes on my siebel database what all indexes are really used and what other indexes that Siebel (now Oracle) has graced us with that is simply sitting there wasting resources.  There … Continue reading

Posted in db2 | Tagged , , , , , , , , | Leave a comment