Community

How to identify unused indexes in DB2 for Linux, UNIX, and Windows

(Dirk Fechner) The DB2 Design Advisor represents a simple method to identify unused indexes. You can use Design Advisor to analyze a set of SQL statements and their execution frequency. As a result of such an analysis, the Design Advisor returns the following information: –Additional index defin

Read More - Register for Free Membership

Tags: