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.