Subject Re: [firebird-support] Index Selectivity
Author Tim Ledgerwood
OK - after rebuilding the indexes, this is what it changed to : (quite a
big change, I thought)

Primary pointer page: 332, Index root page: 333
Data pages: 38439, data page slots: 38439, average fill: 82%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 7
60 - 79% = 15851
80 - 99% = 22581

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

Index IDX_LOGSTOCK (3)
Depth: 3, leaf buckets: 1120, nodes: 179393
Average data length: 0.00, total dup: 178416, max dup: 32723
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1119

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

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

Index IDX_OPT (6)
Depth: 3, leaf buckets: 1121, nodes: 179393
Average data length: 0.00, total dup: 179356, max dup: 32708
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1120

Index IDX_TRANDATA (1)
Depth: 3, leaf buckets: 1121, nodes: 179393
Average data length: 0.00, total dup: 179368, max dup: 32702
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1120

Index IDX_UPDATELOG (7)
Depth: 4, leaf buckets: 6732, nodes: 179393
Average data length: 28.00, total dup: 4901, max dup: 2748
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 6732


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