Detecting indexes not used DB2 9.7

January 22, 2012,   has blogged 27  posts

This article shows a method to view the indexes not used in our database since the last reboot. There are another methods to obtain the same information, like the use of the LASTCOLUMN included on 9.7 version. This article will let you know what indexes are not being used, with the waste of resources involved.