[firebase-br] Entendendo o GSTAT na prática

[Ana Virginia da Silva]

Antes de ir direto ao assunto, gostaria de confirmar a respeito

dos índices: a melhor maneira para atualizá-los é usando

um backup e restore?



Pessoal, gostaria que aqueles que estiverem mais familiarizados 

com o GSTAT me respondessem de forma objetica os números 

obtidos com a tabela exemplo que coloquei abaixo: 

 

 

ITENS (ANTES DO RESTORE) 

 

 

Database "d:\junior\eldora\database\autopecas.fdb" 

 

Database header page information: 

Flags 0 

Checksum 12345 

Generation 79682 

Page size 8192 

ODS version 10.1 

Oldest transaction 66778 

Oldest active 79672 

Oldest snapshot 79672 

Next transaction 79673 

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 Mar 8, 2007 12:33:03 

Attributes force write 

 

Variable header data: 

Sweep interval: 20000 

*END* 

 

 

Database file sequence: 

File d:\junior\eldora\database\autopecas.fdb is the only file 

 

Database log page information: 

Creation date 

Log flags: 2 

No write ahead log 

 

Next log page: 0 

 

Variable log data: 

Control Point 1: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

Control Point 2: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

Current File: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

*END* 

 

Analyzing database pages ... 

 

ESTOQUE_ITENS_SAIDA (154) 

Primary pointer page: 201, Index root page: 202 

Data pages: 1538, data page slots: 1538, average fill: 81% 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 335 

80 - 99% = 1203 

 

Index ESTOQUE_ITENS_SAIDA_IDX1 (1) 

Depth: 2, leaf buckets: 97, nodes: 100848 

Average data length: 0.00, total dup: 89762, max dup: 3392 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 43 

60 - 79% = 0 

80 - 99% = 54 

 

Index FK_ESTOQUE_ITENS_SAIDA_1 (3) 

Depth: 2, leaf buckets: 90, nodes: 100848 

Average data length: 0.00, total dup: 100847, max dup: 100847 

Fill distribution: 

0 - 19% = 1 

20 - 39% = 0 

40 - 59% = 29 

60 - 79% = 1 

80 - 99% = 59 

 

Index FK_ESTOQUE_ITENS_SAIDA_2 (2) 

Depth: 2, leaf buckets: 123, nodes: 100848 

Average data length: 0.00, total dup: 95827, max dup: 521 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 46 

60 - 79% = 77 

80 - 99% = 0 

 

Index FK_ESTOQUE_ITENS_SAIDA_3 (4) 

Depth: 2, leaf buckets: 90, nodes: 100848 

Average data length: 0.00, total dup: 100847, max dup: 100847 

Fill distribution: 

0 - 19% = 1 

20 - 39% = 0 

40 - 59% = 29 

60 - 79% = 1 

80 - 99% = 59 

 

Index PK_ESTOQUE_ITENS_SAIDA (0) 

Depth: 2, leaf buckets: 91, nodes: 100848 

Average data length: 1.00, total dup: 0, max dup: 0 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 8 

60 - 79% = 0 

80 - 99% = 83 

 

 

 

ITENS (DEPOIS DO RESTORE) 

 

 

Database "c:\autopecas.fdb" 

 

Database header page information: 

Flags 0 

Checksum 12345 

Generation 215 

Page size 8192 

ODS version 10.1 

Oldest transaction 1 

Oldest active 2 

Oldest snapshot 1 

Next transaction 209 

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 May 27, 2007 11:24:17 

Attributes force write 

 

Variable header data: 

Sweep interval: 20000 

*END* 

 

 

Database file sequence: 

File c:\autopecas.fdb is the only file 

 

Database log page information: 

Creation date 

Log flags: 2 

No write ahead log 

 

Next log page: 0 

 

Variable log data: 

Control Point 1: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

Control Point 2: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

Current File: 

File name: 

Partition offset: 0 Seqno: 0 Offset: 0 

*END* 

 

Analyzing database pages ... 

 

ESTOQUE_ITENS_SAIDA (154) 

Primary pointer page: 207, Index root page: 208 

Data pages: 1489, data page slots: 1489, average fill: 80% 

Fill distribution: 

0 - 19% = 1 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 482 

80 - 99% = 1006 

 

Index ESTOQUE_ITENS_SAIDA_IDX1 (1) 

Depth: 2, leaf buckets: 76, nodes: 100844 

Average data length: 0.00, total dup: 89759, max dup: 3392 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 1 

80 - 99% = 75 

 

Index FK_ESTOQUE_ITENS_SAIDA_1 (3) 

Depth: 2, leaf buckets: 75, nodes: 100844 

Average data length: 0.00, total dup: 100843, max dup: 100843 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 1 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 74 

 

Index FK_ESTOQUE_ITENS_SAIDA_2 (2) 

Depth: 2, leaf buckets: 75, nodes: 100844 

Average data length: 0.00, total dup: 95823, max dup: 521 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 75 

 

Index FK_ESTOQUE_ITENS_SAIDA_3 (4) 

Depth: 2, leaf buckets: 75, nodes: 100844 

Average data length: 0.00, total dup: 100843, max dup: 100843 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 1 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 74 

 

Index PK_ESTOQUE_ITENS_SAIDA (0) 

Depth: 2, leaf buckets: 87, nodes: 100844 

Average data length: 1.00, total dup: 0, max dup: 0 

Fill distribution: 

0 - 19% = 0 

20 - 39% = 0 

40 - 59% = 0 

60 - 79% = 0 

80 - 99% = 87