Resources

Script to aid in identifying possible redundant indexes in a database

Topic: Code Place

Subtopic: DB2 for LUW



Often a single-column index may not be of great help if there exists a composite index with 2 or more columns having the first column identical to one present in a single-column index. As these are of little use, the enclosed script provides an automated way to report in large environments on such indexes which are good candidates for being dropped.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.