Subject Index Selectivity Tim Ledgerwood 2003-12-08T10:47:02Z
Hi all,

How do I know if the following indexes have too many duplicates? In other
words, when is a chain of duplicates "too long", and when should I consider
dropping the index?

And what is meant by "fill distribution"?

Regards

Tim

Index IDX_LOGSHIFTNUM (1)
Depth: 3, leaf buckets: 1149, nodes: 179393
Average data length: 0.00, total dup: 179090, max dup: 1400
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 83
60 - 79% = 7
80 - 99% = 1059

Index IDX_LOGSTOCK (2)
Depth: 3, leaf buckets: 1904, nodes: 179394
Average data length: 0.00, total dup: 178417, max dup: 32753
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1659
60 - 79% = 91
80 - 99% = 153

Index IDX_LOG_CLIENT (4)
Depth: 3, leaf buckets: 1422, nodes: 179393
Average data length: 0.00, total dup: 179345, max dup: 32675
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 681
60 - 79% = 5
80 - 99% = 736

Index IDX_LOG_CLNT_SUB (6)
Depth: 3, leaf buckets: 1416, nodes: 179393
Average data length: 0.00, total dup: 179386, max dup: 32675
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 678
60 - 79% = 1
80 - 99% = 737

Index IDX_OPT (3)
Depth: 3, leaf buckets: 1938, nodes: 179394
Average data length: 0.00, total dup: 179357, max dup: 32698
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1802
60 - 79% = 12
80 - 99% = 123

Index IDX_UPDATELOG (9)
Depth: 5, leaf buckets: 9734, nodes: 179394
Average data length: 29.00, total dup: 4902, max dup: 2748
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 5207
60 - 79% = 33
80 - 99% = 4491

[Non-text portions of this message have been removed]