When you are building SQL DDL Indexes to improve performance it is also imperative to find Indexes that are not being used. Having identified those a decision can be made on whether to delete these unused indexes, or not.
Finding this information introduced me to a SQL View I had not used before: SYSTABLEINDEXSTAT
SYSTABLEINDEXSTAT contains the columns I want, the number of times the index has been used and the date it was last used. Alas, the view SYSINDEXES does not contain that information.
I always recommend that, on the partition you use, you run the following statement at least once to see all of the information that is available to you:
SELECT * FROM QSYS2.SYSTABLEINDEXSTAT
LIMIT 10 ;
Read more »
