Opportunistic Tuning — Eliminate Unused Indexes

Well, just when you think everything is running fine, I bet you can make it better by following this tip. First you’ll want to make sure you are at DB2 9.7 FP 3A. In 9.7 the LASTUSED column was added to SYSIBM.SYSINDEXES. This column will record the date the index was last used or accessed. Make sure you are on FP3A as this fixed a problem with the column bot being updated under certain conditions. Select this column for your table or tables of interest and start getting rid of unused indexes. Of course, conduct a sanity check before dropping them. Stay tuned! Happy New Year!