Discussion :

[calou_33]

Bonjour,

Voici un extrait des stats de ma base

Analyzing database pages ...
AFFECT_DATA_STATUS (137)
Primary pointer page: 165, Index root page: 166
Data pages: 26812, data page slots: 26812, average fill: 81%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4628
80 - 99% = 22183

Index I_AFFECT_DATA_STATUS_DATE (3)
Depth: 2, leaf buckets: 1118, nodes: 3458914
Average data length: 0.17, total dup: 3251448, max dup: 63
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1117

Index I_AFFECT_DATA_STATUS_PROJET (1)
Depth: 2, leaf buckets: 1062, nodes: 3458914
Average data length: 0.00, total dup: 3458903, max dup: 1040032
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1061

Index I_AFFECT_DATA_STATUS_TURBINE (2)
Depth: 2, leaf buckets: 1062, nodes: 3458914
Average data length: 0.00, total dup: 3458902, max dup: 770507
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1061

Index PK_AFFECT_DATA_STATUS (0)
Depth: 3, leaf buckets: 2466, nodes: 3458914
Average data length: 5.56, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2465

Je ne sais pas trop comment interpréter ces données

Merci

[makowski]

voir ici :
http://www.ibphoenix.com/main.nfs?a=...nf_opt#Indices

ou dans le livre d'Helen Borrie : http://ibphoenix.com/main.nfs?a=ibph..._firebird_book

ou suivre une formation

[calou_33]

Merci