Subject total records and total versions bigger than expected
Author Juan Jose Ochoa
Hi!

Can someone tell me please why the statistics of the table say I have
8272 records when I only have 30.

This morning it said that I had 80000~ when I really had about two
hundred.

Thanks
Juan Jose

Statistics:
-----------------------------------------------------------------
REPL_LOG (250)
Primary pointer page: 1455, Index root page: 1456
Average record length: 2.13, total records: 8272
Average version length: 47.53, total versions: 7903, max
versions: 1
Data pages: 90, data page slots: 848, average fill: 91%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 85

Index I_REPL_LOG (1)
Depth: 2, leaf buckets: 9, nodes: 8272
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7

Index RDB$PRIMARY22 (0)
Depth: 2, leaf buckets: 9, nodes: 8272
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7

Database statistics:
---------------------------------------------------------------
Database header page information:
Flags 0
Checksum 12345
Generation 308404
Page size 8192
ODS version 10.1
Oldest transaction 304318
Oldest active 304319
Oldest snapshot 301818
Next transaction 308396
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jul 19, 2005 15:57:46
Attributes force write