Is there someone who can help me to read those statistics ?
Database header page information:
Flags 0
Checksum 12345
Generation 237
Page size 8192
ODS version 10.0
Oldest transaction 1
Oldest active 2
Oldest snapshot 1
Next transaction 231
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 Jan 21, 2003 18:20:15
Attributes force write
CMOTP_MATRICE (129)

Index CMOTP_MATRICE_IDX1 (1)
Depth: 2, leaf buckets: 360, nodes: 487329
Average data length: 0.00, total dup: 487321, max dup: 32673
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 359

Index CMOTP_MATRICE_IDX10 (2)
Depth: 2, leaf buckets: 367, nodes: 487329
Average data length: 0.00, total dup: 487327, max dup: 32730
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 367

Index CMOTP_MATRICE_IDX11 (3)
Depth: 2, leaf buckets: 372, nodes: 487329
Average data length: 0.00, total dup: 403414, max dup: 32682
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 371

Index CMOTP_MATRICE_IDX2 (11)
Depth: 2, leaf buckets: 360, nodes: 487329
Average data length: 0.00, total dup: 487289, max dup: 32423
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 359

Index CMOTP_MATRICE_IDX3 (4)
Depth: 2, leaf buckets: 360, nodes: 487329
Average data length: 0.00, total dup: 486650, max dup: 16224
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 359

Index CMOTP_MATRICE_IDX4 (5)
Depth: 2, leaf buckets: 361, nodes: 487329
Average data length: 0.00, total dup: 487328, max dup: 32663
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 360

Index CMOTP_MATRICE_IDX5 (6)
Depth: 2, leaf buckets: 361, nodes: 487329
Average data length: 0.00, total dup: 487328, max dup: 32663
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 360

Index CMOTP_MATRICE_IDX6 (7)
Depth: 2, leaf buckets: 361, nodes: 487329
Average data length: 0.00, total dup: 487325, max dup: 32698
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 360

Index CMOTP_MATRICE_IDX7 (8)
Depth: 2, leaf buckets: 361, nodes: 487329
Average data length: 0.00, total dup: 487328, max dup: 32663
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 360

Index CMOTP_MATRICE_IDX8 (9)
Depth: 2, leaf buckets: 361, nodes: 487329
Average data length: 0.00, total dup: 484666, max dup: 5903
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 360

Index CMOTP_MATRICE_IDX9 (10)
Depth: 3, leaf buckets: 1219, nodes: 487329
Average data length: 14.00, total dup: 320399, max dup: 32607
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1218

Index RDB$PRIMARY2 (0)
Depth: 3, leaf buckets: 980, nodes: 487329
Average data length: 10.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 980


--
Philippe Makowski
A6-CMO
20 rue Martin Bernard 75013 Paris France
Téléphone/Office : +33 1 53 62 71 51
Ligne Directe/Direct line : +33 5 61 05 88 13
Fax : +33 1 53 62 71 54
http://www.a6cmo.fr

Firebird serveur SQL open-source en français
http://firebird-fr.eu.org

Ma clé PGP : http://makowski.eu.org/pgpkey.html