| 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]