Need script for finding out duplicate indexes on tables

[santhosh238]

I need script for finding out duplicate indexes on tables in sybase.

I need something like this :

to finds partial, or duplicate (loverlapping), indexes that share leading key columns, e.g. Ix1(col1, col2, col3) and Ix2(col1, col2) would be considered duplicate indexes where Ix1 is sufficient and Ix2 can be dropped .

I need script for this please.

Thanks in advance

 

[PDreyer]

Have a look at the code for sp_helpindex