Skip to content

Opportunistic Tuning — Eliminate Unused Indexes

January 1, 2015

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!

From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

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

%d bloggers like this: