Skip to content

Do Some Summer Housekeeping — Drop Unused Indexes

August 11, 2016

The LASTUSED column was introduced in DB2 9.7 FP3A. It added an index last used column to SYSCAT.INDEXES. Of course before this was introduced we could back into unused indexes using the tcbstats option of db2pd. I have used this feature to drop many unused, duplicate and redundant indexes and achieved performance improvements by doing this.  However, as new objects are create, new queries developed, queries modified, indexes can become unused over time. Hence it is therefore important to review index usage on a regular basis and identify and drop unused indexes. So with the summer winding down, get movin’.

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: