Code Place

Script to aid in identifying possible redundant indexes in a database 

Oct 28, 2011 05:32 AM

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.

Attachment(s)
txt file
db2-script-to-aid-in-identifying-redundant-indexes.txt   1 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.