Subject | Index question |
---|---|

Author | Yves Glodt |

Post date | 2003-10-24T13:22:16Z |

Hello,

we are trying to enhance performance of an application we resell.

It has about 50 tables, and one of them contains many rows

of calculated data (about 1300000). The field IPN is the persons id who

the data belongs to. With 45 persons, that makes ~28000 records per person.

Selects are mostly made of the 5th column, with the first

4 columns in the where-clause.

My question is about the index definition of this special table.

This is how we get it:

CREATE TABLE WT_CPT_VAL (

IPN INTEGER NOT NULL,

COUNTER_VALUE_GROUP SMALLINT NOT NULL,

COUNTER_VALUE_NUMBER SMALLINT NOT NULL,

COUNTER_VALUE_DATE INTEGER NOT NULL,

COUNTER_VALUE_VALUE DOUBLE PRECISION,

PRIMARY KEY (IPN, COUNTER_VALUE_GROUP, COUNTER_VALUE_NUMBER,

COUNTER_VALUE_DATE)

);

CREATE INDEX WT_CPT_VAL_IC1C4 ON WT_CPT_VAL(IPN, COUNTER_VALUE_DATE);

1. Would it make sense to add one or more of these indexes:

CREATE INDEX WT_CPT_VAL_INDEX_1 ON WT_CPT_VAL(IPN);

CREATE INDEX WT_CPT_VAL_INDEX_2 ON WT_CPT_VAL(COUNTER_VALUE_GROUP);

CREATE INDEX WT_CPT_VAL_INDEX_3 ON WT_CPT_VAL(COUNTER_VALUE_NUMBER);

CREATE INDEX WT_CPT_VAL_INDEX_4 ON WT_CPT_VAL(COUNTER_VALUE_DATE);

2. Or would it make sense to recreate the table with this definition:

CREATE TABLE WT_CPT_VAL (

IPN INTEGER NOT NULL,

COUNTER_VALUE_GROUP SMALLINT NOT NULL,

COUNTER_VALUE_NUMBER SMALLINT NOT NULL,

COUNTER_VALUE_DATE INTEGER NOT NULL,

COUNTER_VALUE_VALUE DOUBLE PRECISION

);

and then add these indexes again:

CREATE INDEX WT_CPT_VAL_INDEX_1 ON WT_CPT_VAL(IPN);

CREATE INDEX WT_CPT_VAL_INDEX_2 ON WT_CPT_VAL(COUNTER_VALUE_GROUP);

CREATE INDEX WT_CPT_VAL_INDEX_3 ON WT_CPT_VAL(COUNTER_VALUE_NUMBER);

CREATE INDEX WT_CPT_VAL_INDEX_4 ON WT_CPT_VAL(COUNTER_VALUE_DATE);

I am aware that this definition contains no more constraints, but the

application can handle that. I use FB 1.03.

I attached the index stats from the db, and would be very happy about

any hint or advice.

kind regards,

Yves Glodt

----------

Database header page information:

Flags 0

Checksum 12345

Generation 8548335

Page size 4096

ODS version 10.0

Oldest transaction 8548323

Oldest active 8548324

Oldest snapshot 8548324

Next transaction 8548325

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 1

Creation date Jul 23, 2003 13:44:24

Variable header data:

Sweep interval: 200000

*END*

Database file sequence:

File e:\wintime\ib\wintime.gdb 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 ...

ES_CLIENTS (175)

Index ES_CLIENTS_INDEX_1 (1)

Depth: 1, leaf buckets: 1, nodes: 127

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY51 (0)

Depth: 1, leaf buckets: 1, nodes: 127

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

ES_DOSSIERS (177)

Index INDEX_ES_DOSSIERS_2 (0)

Depth: 2, leaf buckets: 13, nodes: 1354

Average data length: 14.00, total dup: 21, max dup: 4

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 13

60 - 79% = 0

80 - 99% = 0

Index INDEX_ES_DOSSIERS_3 (1)

Depth: 2, leaf buckets: 6, nodes: 1354

Average data length: 3.00, total dup: 599, max dup: 305

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 5

60 - 79% = 1

80 - 99% = 0

Index INDEX_ES_DOSSIERS_4 (2)

Depth: 2, leaf buckets: 5, nodes: 1354

Average data length: 0.00, total dup: 52, max dup: 6

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 4

60 - 79% = 0

80 - 99% = 0

Index INDEX_ES_DOSSIERS_5 (3)

Depth: 2, leaf buckets: 3, nodes: 1354

Average data length: 0.00, total dup: 1347, max dup: 1301

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 2

60 - 79% = 0

80 - 99% = 1

Index RDB$PRIMARY84 (4)

Depth: 2, leaf buckets: 5, nodes: 1354

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 4

60 - 79% = 0

80 - 99% = 1

ES_DOSSIERS_MVT (178)

Index ES_DOSSIERS_MVT_INDEX_1 (2)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 3.00, total dup: 4, max dup: 2

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_2 (6)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 1.00, total dup: 5, max dup: 3

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_3 (7)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 0.00, total dup: 42, max dup: 41

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_4 (8)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 20.00, total dup: 4, max dup: 2

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_5 (9)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 2.00, total dup: 5, max dup: 2

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_6 (10)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 0.00, total dup: 43, max dup: 23

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY87 (1)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

ES_PROJETS (171)

Index ES_PROJETS_INDEX_1 (0)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 2.00, total dup: 5, max dup: 1

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_2 (2)

Depth: 2, leaf buckets: 3, nodes: 297

Average data length: 14.00, total dup: 48, max dup: 7

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_3 (3)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 0.00, total dup: 295, max dup: 217

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_4 (4)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 0.00, total dup: 286, max dup: 215

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY48 (1)

Depth: 1, leaf buckets: 1, nodes: 297

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

ES_SORTIES (172)

Index ES_SORTIES_INDEX_1 (3)

Depth: 2, leaf buckets: 7, nodes: 4107

Average data length: 0.00, total dup: 3794, max dup: 29

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 1

80 - 99% = 5

Index ES_SORTIES_INDEX_2 (2)

Depth: 2, leaf buckets: 11, nodes: 4107

Average data length: 0.00, total dup: 3963, max dup: 767

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 5

60 - 79% = 6

80 - 99% = 0

Index ES_SORTIES_INDEX_3 (4)

Depth: 2, leaf buckets: 7, nodes: 4107

Average data length: 0.00, total dup: 4041, max dup: 98

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 1

80 - 99% = 5

Index ES_SORTIES_INDEX_4 (1)

Depth: 2, leaf buckets: 9, nodes: 4107

Average data length: 0.00, total dup: 3670, max dup: 2228

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 4

60 - 79% = 3

80 - 99% = 2

Index ES_SORTIES_RDB$PRIMARY6 (0)

Depth: 2, leaf buckets: 8, nodes: 4107

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 7

ES_TELEPHONE (173)

Index ES_TELEPHONE_INDEX_1 (1)

Depth: 2, leaf buckets: 2, nodes: 1131

Average data length: 0.00, total dup: 938, max dup: 18

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 0

60 - 79% = 1

80 - 99% = 1

Index ES_TELEPHONE_INDEX_2 (2)

Depth: 2, leaf buckets: 3, nodes: 1131

Average data length: 0.00, total dup: 1098, max dup: 183

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 2

80 - 99% = 0

Index ES_TELEPHONE_INDEX_3 (3)

Depth: 2, leaf buckets: 3, nodes: 1131

Average data length: 0.00, total dup: 1127, max dup: 717

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 1

60 - 79% = 0

80 - 99% = 1

Index RDB$PRIMARY53 (0)

Depth: 2, leaf buckets: 2, nodes: 1131

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% = 2

ES_USERS (176)

Index ES_USERS_INDEX_1 (0)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY58 (1)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

EXPORT2_TMP (185)

Index EXPORT2_TMP_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 55

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

EXPORT_TMP (184)

Index EXPORT_TMP_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 105

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

SYSTEM (128)

Index RDB$PRIMARY1 (0)

Depth: 1, leaf buckets: 1, nodes: 56

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WTKEY (166)

Index RDB$PRIMARY40 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WTWEBSES (168)

Index RDB$PRIMARY43 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_ANNOT (138)

Index RDB$PRIMARY12 (0)

Depth: 1, leaf buckets: 1, nodes: 141

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CODE (151)

Index RDB$PRIMARY28 (0)

Depth: 1, leaf buckets: 1, nodes: 91

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CONC (155)

Index RDB$PRIMARY32 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CORR (156)

Index RDB$PRIMARY33 (0)

Depth: 3, leaf buckets: 225, nodes: 51743

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 62

60 - 79% = 13

80 - 99% = 149

Index WT_CORR_IC1C3C2 (1)

Depth: 2, leaf buckets: 151, nodes: 51743

Average data length: 1.00, total dup: 479, max dup: 33

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 109

60 - 79% = 12

80 - 99% = 29

Index WT_CORR_IC4 (2)

Depth: 2, leaf buckets: 89, nodes: 51743

Average data length: 0.00, total dup: 5220, max dup: 55

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 0

60 - 79% = 1

80 - 99% = 88

WT_CORRCOLL (157)

Index RDB$PRIMARY34 (0)

Depth: 1, leaf buckets: 1, nodes: 50

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CPT (148)

Index RDB$PRIMARY25 (0)

Depth: 1, leaf buckets: 1, nodes: 122

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CPT_VAL (159)

Index RDB$PRIMARY36 (0)

Depth: 3, leaf buckets: 3106, nodes: 1292378

Average data length: 1.00, total dup: 2, max dup: 1

Fill distribution:

0 - 19% = 3

20 - 39% = 2

40 - 59% = 1232

60 - 79% = 691

80 - 99% = 1178

Index WT_CPT_VAL_IC1C4 (1)

Depth: 3, leaf buckets: 2488, nodes: 1292378

Average data length: 0.00, total dup: 1223847, max dup: 34

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1078

60 - 79% = 21

80 - 99% = 1389

WT_DROITS (131)

Index RDB$PRIMARY4 (0)

Depth: 2, leaf buckets: 5, nodes: 1340

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 2

60 - 79% = 0

80 - 99% = 3

WT_ECRANS (152)

Index RDB$PRIMARY29 (0)

Depth: 1, leaf buckets: 1, nodes: 18

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_EXPORT_D (174)

Index WT_EXPORT_D_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 80

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_EXPORT_G (169)

Index WT_EXPORT_G_RDB$PRIMARY18 (0)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_FENETRE (154)

Index RDB$PRIMARY31 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_FERIES (144)

Index RDB$PRIMARY21 (0)

Depth: 1, leaf buckets: 1, nodes: 31

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_IMPORT_D (140)

Index RDB$PRIMARY15 (0)

Depth: 1, leaf buckets: 1, nodes: 44

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_IMPORT_G (170)

Index WT_IMPORT_G_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_LOG (137)

Index RDB$PRIMARY11 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_MOTIFS (147)

Index RDB$PRIMARY24 (0)

Depth: 1, leaf buckets: 1, nodes: 86

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_MVT (158)

Index RDB$PRIMARY35 (0)

Depth: 3, leaf buckets: 356, nodes: 67655

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 44

60 - 79% = 9

80 - 99% = 303

WT_NCHAMPS (135)

Index RDB$PRIMARY8 (0)

Depth: 1, leaf buckets: 1, nodes: 120

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_NOMS (160)

Index WT_NOMS_RDB$PRIMARY6 (0)

Depth: 2, leaf buckets: 3, nodes: 652

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

WT_PERIODES (153)

Index RDB$PRIMARY30 (0)

Depth: 1, leaf buckets: 1, nodes: 24

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS (133)

Index WT_PERS_IC2 (1)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_IC3 (2)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_IC4 (3)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_RDB$PRIMARY37 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_ACS (162)

Index RDB$PRIMARY39 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_ES (164)

Index WT_PERS_ES_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_KID (163)

Index WT_PERS_KID_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_TPS (161)

Index RDB$PRIMARY38 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PLAN (146)

Index RDB$PRIMARY23 (0)

Depth: 1, leaf buckets: 1, nodes: 32

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PRINT (142)

Index RDB$PRIMARY17 (0)

Depth: 2, leaf buckets: 3, nodes: 1417

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 2

WT_PRINTOUT (141)

Index RDB$PRIMARY16 (0)

Depth: 1, leaf buckets: 1, nodes: 24

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PRJ (145)

Index RDB$PRIMARY22 (0)

Depth: 1, leaf buckets: 1, nodes: 222

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

WT_SEQ (132)

Index RDB$PRIMARY5 (0)

Depth: 1, leaf buckets: 1, nodes: 10

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TABLES (129)

Index RDB$PRIMARY2 (0)

Depth: 1, leaf buckets: 1, nodes: 41

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TCHAMPS (136)

Index RDB$PRIMARY9 (0)

Depth: 1, leaf buckets: 1, nodes: 108

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TEXTES (165)

Index WT_TEXTES_RDB$PRIMARY10 (0)

Depth: 2, leaf buckets: 8, nodes: 4139

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 7

WT_TM (149)

Index RDB$PRIMARY26 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TRANS (139)

Index RDB$PRIMARY13 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_USER (130)

Index RDB$PRIMARY3 (0)

Depth: 1, leaf buckets: 1, nodes: 20

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_USER_IC2 (1)

Depth: 1, leaf buckets: 1, nodes: 20

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_USES (134)

Index RDB$PRIMARY7 (0)

Depth: 2, leaf buckets: 3, nodes: 705

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

WT_WATCHER (143)

Index RDB$PRIMARY20 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_ZONES (150)

Index RDB$PRIMARY27 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Service ended at 24.10.2003 15:14:44

[Non-text portions of this message have been removed]

we are trying to enhance performance of an application we resell.

It has about 50 tables, and one of them contains many rows

of calculated data (about 1300000). The field IPN is the persons id who

the data belongs to. With 45 persons, that makes ~28000 records per person.

Selects are mostly made of the 5th column, with the first

4 columns in the where-clause.

My question is about the index definition of this special table.

This is how we get it:

CREATE TABLE WT_CPT_VAL (

IPN INTEGER NOT NULL,

COUNTER_VALUE_GROUP SMALLINT NOT NULL,

COUNTER_VALUE_NUMBER SMALLINT NOT NULL,

COUNTER_VALUE_DATE INTEGER NOT NULL,

COUNTER_VALUE_VALUE DOUBLE PRECISION,

PRIMARY KEY (IPN, COUNTER_VALUE_GROUP, COUNTER_VALUE_NUMBER,

COUNTER_VALUE_DATE)

);

CREATE INDEX WT_CPT_VAL_IC1C4 ON WT_CPT_VAL(IPN, COUNTER_VALUE_DATE);

1. Would it make sense to add one or more of these indexes:

CREATE INDEX WT_CPT_VAL_INDEX_1 ON WT_CPT_VAL(IPN);

CREATE INDEX WT_CPT_VAL_INDEX_2 ON WT_CPT_VAL(COUNTER_VALUE_GROUP);

CREATE INDEX WT_CPT_VAL_INDEX_3 ON WT_CPT_VAL(COUNTER_VALUE_NUMBER);

CREATE INDEX WT_CPT_VAL_INDEX_4 ON WT_CPT_VAL(COUNTER_VALUE_DATE);

2. Or would it make sense to recreate the table with this definition:

CREATE TABLE WT_CPT_VAL (

IPN INTEGER NOT NULL,

COUNTER_VALUE_GROUP SMALLINT NOT NULL,

COUNTER_VALUE_NUMBER SMALLINT NOT NULL,

COUNTER_VALUE_DATE INTEGER NOT NULL,

COUNTER_VALUE_VALUE DOUBLE PRECISION

);

and then add these indexes again:

CREATE INDEX WT_CPT_VAL_INDEX_1 ON WT_CPT_VAL(IPN);

CREATE INDEX WT_CPT_VAL_INDEX_2 ON WT_CPT_VAL(COUNTER_VALUE_GROUP);

CREATE INDEX WT_CPT_VAL_INDEX_3 ON WT_CPT_VAL(COUNTER_VALUE_NUMBER);

CREATE INDEX WT_CPT_VAL_INDEX_4 ON WT_CPT_VAL(COUNTER_VALUE_DATE);

I am aware that this definition contains no more constraints, but the

application can handle that. I use FB 1.03.

I attached the index stats from the db, and would be very happy about

any hint or advice.

kind regards,

Yves Glodt

----------

Database header page information:

Flags 0

Checksum 12345

Generation 8548335

Page size 4096

ODS version 10.0

Oldest transaction 8548323

Oldest active 8548324

Oldest snapshot 8548324

Next transaction 8548325

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 1

Creation date Jul 23, 2003 13:44:24

Variable header data:

Sweep interval: 200000

*END*

Database file sequence:

File e:\wintime\ib\wintime.gdb 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 ...

ES_CLIENTS (175)

Index ES_CLIENTS_INDEX_1 (1)

Depth: 1, leaf buckets: 1, nodes: 127

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY51 (0)

Depth: 1, leaf buckets: 1, nodes: 127

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

ES_DOSSIERS (177)

Index INDEX_ES_DOSSIERS_2 (0)

Depth: 2, leaf buckets: 13, nodes: 1354

Average data length: 14.00, total dup: 21, max dup: 4

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 13

60 - 79% = 0

80 - 99% = 0

Index INDEX_ES_DOSSIERS_3 (1)

Depth: 2, leaf buckets: 6, nodes: 1354

Average data length: 3.00, total dup: 599, max dup: 305

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 5

60 - 79% = 1

80 - 99% = 0

Index INDEX_ES_DOSSIERS_4 (2)

Depth: 2, leaf buckets: 5, nodes: 1354

Average data length: 0.00, total dup: 52, max dup: 6

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 4

60 - 79% = 0

80 - 99% = 0

Index INDEX_ES_DOSSIERS_5 (3)

Depth: 2, leaf buckets: 3, nodes: 1354

Average data length: 0.00, total dup: 1347, max dup: 1301

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 2

60 - 79% = 0

80 - 99% = 1

Index RDB$PRIMARY84 (4)

Depth: 2, leaf buckets: 5, nodes: 1354

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 4

60 - 79% = 0

80 - 99% = 1

ES_DOSSIERS_MVT (178)

Index ES_DOSSIERS_MVT_INDEX_1 (2)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 3.00, total dup: 4, max dup: 2

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_2 (6)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 1.00, total dup: 5, max dup: 3

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_3 (7)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 0.00, total dup: 42, max dup: 41

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_4 (8)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 20.00, total dup: 4, max dup: 2

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_5 (9)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 2.00, total dup: 5, max dup: 2

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index ES_DOSSIERS_MVT_INDEX_6 (10)

Depth: 1, leaf buckets: 1, nodes: 45

Average data length: 0.00, total dup: 43, max dup: 23

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY87 (1)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

ES_PROJETS (171)

Index ES_PROJETS_INDEX_1 (0)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 2.00, total dup: 5, max dup: 1

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_2 (2)

Depth: 2, leaf buckets: 3, nodes: 297

Average data length: 14.00, total dup: 48, max dup: 7

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_3 (3)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 0.00, total dup: 295, max dup: 217

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index ES_PROJETS_INDEX_4 (4)

Depth: 1, leaf buckets: 1, nodes: 297

Average data length: 0.00, total dup: 286, max dup: 215

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY48 (1)

Depth: 1, leaf buckets: 1, nodes: 297

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

ES_SORTIES (172)

Index ES_SORTIES_INDEX_1 (3)

Depth: 2, leaf buckets: 7, nodes: 4107

Average data length: 0.00, total dup: 3794, max dup: 29

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 1

80 - 99% = 5

Index ES_SORTIES_INDEX_2 (2)

Depth: 2, leaf buckets: 11, nodes: 4107

Average data length: 0.00, total dup: 3963, max dup: 767

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 5

60 - 79% = 6

80 - 99% = 0

Index ES_SORTIES_INDEX_3 (4)

Depth: 2, leaf buckets: 7, nodes: 4107

Average data length: 0.00, total dup: 4041, max dup: 98

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 1

80 - 99% = 5

Index ES_SORTIES_INDEX_4 (1)

Depth: 2, leaf buckets: 9, nodes: 4107

Average data length: 0.00, total dup: 3670, max dup: 2228

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 4

60 - 79% = 3

80 - 99% = 2

Index ES_SORTIES_RDB$PRIMARY6 (0)

Depth: 2, leaf buckets: 8, nodes: 4107

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 7

ES_TELEPHONE (173)

Index ES_TELEPHONE_INDEX_1 (1)

Depth: 2, leaf buckets: 2, nodes: 1131

Average data length: 0.00, total dup: 938, max dup: 18

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 0

60 - 79% = 1

80 - 99% = 1

Index ES_TELEPHONE_INDEX_2 (2)

Depth: 2, leaf buckets: 3, nodes: 1131

Average data length: 0.00, total dup: 1098, max dup: 183

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 2

80 - 99% = 0

Index ES_TELEPHONE_INDEX_3 (3)

Depth: 2, leaf buckets: 3, nodes: 1131

Average data length: 0.00, total dup: 1127, max dup: 717

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 1

60 - 79% = 0

80 - 99% = 1

Index RDB$PRIMARY53 (0)

Depth: 2, leaf buckets: 2, nodes: 1131

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% = 2

ES_USERS (176)

Index ES_USERS_INDEX_1 (0)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index RDB$PRIMARY58 (1)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

EXPORT2_TMP (185)

Index EXPORT2_TMP_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 55

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

EXPORT_TMP (184)

Index EXPORT_TMP_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 105

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

SYSTEM (128)

Index RDB$PRIMARY1 (0)

Depth: 1, leaf buckets: 1, nodes: 56

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WTKEY (166)

Index RDB$PRIMARY40 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WTWEBSES (168)

Index RDB$PRIMARY43 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_ANNOT (138)

Index RDB$PRIMARY12 (0)

Depth: 1, leaf buckets: 1, nodes: 141

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CODE (151)

Index RDB$PRIMARY28 (0)

Depth: 1, leaf buckets: 1, nodes: 91

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CONC (155)

Index RDB$PRIMARY32 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CORR (156)

Index RDB$PRIMARY33 (0)

Depth: 3, leaf buckets: 225, nodes: 51743

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 62

60 - 79% = 13

80 - 99% = 149

Index WT_CORR_IC1C3C2 (1)

Depth: 2, leaf buckets: 151, nodes: 51743

Average data length: 1.00, total dup: 479, max dup: 33

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 109

60 - 79% = 12

80 - 99% = 29

Index WT_CORR_IC4 (2)

Depth: 2, leaf buckets: 89, nodes: 51743

Average data length: 0.00, total dup: 5220, max dup: 55

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 0

60 - 79% = 1

80 - 99% = 88

WT_CORRCOLL (157)

Index RDB$PRIMARY34 (0)

Depth: 1, leaf buckets: 1, nodes: 50

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CPT (148)

Index RDB$PRIMARY25 (0)

Depth: 1, leaf buckets: 1, nodes: 122

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_CPT_VAL (159)

Index RDB$PRIMARY36 (0)

Depth: 3, leaf buckets: 3106, nodes: 1292378

Average data length: 1.00, total dup: 2, max dup: 1

Fill distribution:

0 - 19% = 3

20 - 39% = 2

40 - 59% = 1232

60 - 79% = 691

80 - 99% = 1178

Index WT_CPT_VAL_IC1C4 (1)

Depth: 3, leaf buckets: 2488, nodes: 1292378

Average data length: 0.00, total dup: 1223847, max dup: 34

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1078

60 - 79% = 21

80 - 99% = 1389

WT_DROITS (131)

Index RDB$PRIMARY4 (0)

Depth: 2, leaf buckets: 5, nodes: 1340

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 2

60 - 79% = 0

80 - 99% = 3

WT_ECRANS (152)

Index RDB$PRIMARY29 (0)

Depth: 1, leaf buckets: 1, nodes: 18

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_EXPORT_D (174)

Index WT_EXPORT_D_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 80

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_EXPORT_G (169)

Index WT_EXPORT_G_RDB$PRIMARY18 (0)

Depth: 1, leaf buckets: 1, nodes: 2

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_FENETRE (154)

Index RDB$PRIMARY31 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_FERIES (144)

Index RDB$PRIMARY21 (0)

Depth: 1, leaf buckets: 1, nodes: 31

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_IMPORT_D (140)

Index RDB$PRIMARY15 (0)

Depth: 1, leaf buckets: 1, nodes: 44

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_IMPORT_G (170)

Index WT_IMPORT_G_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_LOG (137)

Index RDB$PRIMARY11 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_MOTIFS (147)

Index RDB$PRIMARY24 (0)

Depth: 1, leaf buckets: 1, nodes: 86

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_MVT (158)

Index RDB$PRIMARY35 (0)

Depth: 3, leaf buckets: 356, nodes: 67655

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 44

60 - 79% = 9

80 - 99% = 303

WT_NCHAMPS (135)

Index RDB$PRIMARY8 (0)

Depth: 1, leaf buckets: 1, nodes: 120

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_NOMS (160)

Index WT_NOMS_RDB$PRIMARY6 (0)

Depth: 2, leaf buckets: 3, nodes: 652

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

WT_PERIODES (153)

Index RDB$PRIMARY30 (0)

Depth: 1, leaf buckets: 1, nodes: 24

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS (133)

Index WT_PERS_IC2 (1)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_IC3 (2)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_IC4 (3)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_PERS_RDB$PRIMARY37 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_ACS (162)

Index RDB$PRIMARY39 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_ES (164)

Index WT_PERS_ES_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_KID (163)

Index WT_PERS_KID_INDEX1 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PERS_TPS (161)

Index RDB$PRIMARY38 (0)

Depth: 1, leaf buckets: 1, nodes: 45

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PLAN (146)

Index RDB$PRIMARY23 (0)

Depth: 1, leaf buckets: 1, nodes: 32

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PRINT (142)

Index RDB$PRIMARY17 (0)

Depth: 2, leaf buckets: 3, nodes: 1417

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 2

WT_PRINTOUT (141)

Index RDB$PRIMARY16 (0)

Depth: 1, leaf buckets: 1, nodes: 24

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_PRJ (145)

Index RDB$PRIMARY22 (0)

Depth: 1, leaf buckets: 1, nodes: 222

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 0

WT_SEQ (132)

Index RDB$PRIMARY5 (0)

Depth: 1, leaf buckets: 1, nodes: 10

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TABLES (129)

Index RDB$PRIMARY2 (0)

Depth: 1, leaf buckets: 1, nodes: 41

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TCHAMPS (136)

Index RDB$PRIMARY9 (0)

Depth: 1, leaf buckets: 1, nodes: 108

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TEXTES (165)

Index WT_TEXTES_RDB$PRIMARY10 (0)

Depth: 2, leaf buckets: 8, nodes: 4139

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

Fill distribution:

0 - 19% = 0

20 - 39% = 0

40 - 59% = 1

60 - 79% = 0

80 - 99% = 7

WT_TM (149)

Index RDB$PRIMARY26 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_TRANS (139)

Index RDB$PRIMARY13 (0)

Depth: 1, leaf buckets: 1, nodes: 1

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_USER (130)

Index RDB$PRIMARY3 (0)

Depth: 1, leaf buckets: 1, nodes: 20

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Index WT_USER_IC2 (1)

Depth: 1, leaf buckets: 1, nodes: 20

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_USES (134)

Index RDB$PRIMARY7 (0)

Depth: 2, leaf buckets: 3, nodes: 705

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

Fill distribution:

0 - 19% = 0

20 - 39% = 1

40 - 59% = 2

60 - 79% = 0

80 - 99% = 0

WT_WATCHER (143)

Index RDB$PRIMARY20 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

WT_ZONES (150)

Index RDB$PRIMARY27 (0)

Depth: 1, leaf buckets: 1, nodes: 0

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

Fill distribution:

0 - 19% = 1

20 - 39% = 0

40 - 59% = 0

60 - 79% = 0

80 - 99% = 0

Service ended at 24.10.2003 15:14:44

[Non-text portions of this message have been removed]