Subject | Re: [firebird-support] Index Selectivity |
---|---|
Author | Tim Ledgerwood |
Post date | 2003-12-08T12:42:05Z |
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]
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]