A developer has created the following indexes. To me 1 and 3 are all the same except RRCTY is in 3 (but only has 4 distinct values). Index 2 does not look to good either. Table ZZDUQT is about 30GB. I would like to ask some opinions.
NONUNIQUE Index ZZDUQT~2
Column Name #Distinct
RCLNT 1
RYEAR 11
RVERS 10
RCOSTCTR 1,683
RACCT 6,462
RPRCTR 1,793
NONUNIQUE Index ZZDUQT~3
Column Name #Distinct
RCLNT 1
RYEAR 11
RVERS 10
RLDNR 2
RRCTY 4
RBUKRS 230
RACCT 6,462
RCOSTCTR 1,683
RPRCTR 1,793
NONUNIQUE Index ZZDUQT~1
Column Name #Distinct
RYEAR 11
RVERS 10
RLDNR 2
RBUKRS 230
RACCT 6,462
UNIQUE Index ZZDUQ~0
Column Name #Distinct
RCLNT 1
RLDNR 2
RRCTY 4
RVERS 10
RYEAR 11
ROBJNR 337,305
COBJNR 32,300
SOBJNR 1
RTCUR 15
RUNIT 1
DRCRK 1
RPMAX 1