Skip to Content
0
Former Member
Jan 15, 2008 at 04:50 PM

Indexes

20 Views

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