Subject | total records and total versions bigger than expected |
---|---|
Author | Juan Jose Ochoa |
Post date | 2005-07-29T18:42:14Z |
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
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