Redundant Indexes

[Keith Owens]

Hi All,

HPUX 11
Progress 8.3E char

Is there an easy way for me to identify redundant indexes or do I need to compile all my sources with XREF and then plough through the output.

Thanks in advance

Keith
DBA Under Stress

 

[livetocode]

Are you looking for redundant indexes defined in a table(s) if so you do not need to compile the source. You need to examine the sub-schema files where the indexes are defined and compare then to one another at the table level. Indexes with the same fields or same fields at the beginning of the composite structure are candidates for redundancy.