| Subject | Re: Database file grows |
|---|---|
| Author | lsbtreis |
| Post date | 2005-06-21T09:41:08Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
crashes. For the logs that my aplications write I can see that the
processes are not crashing because of the database but when this
happens the connections to the database are oppened and most of the
times inserting records.
The database has 43 tables. This tables are divided in 3 logical
groups (A, B and C). The tables in this groups are not related in
the database, this means that inserting in a table of A does not
afect the B or C tables.
The configuration of this aplications is as foillows:
1) This aplication is always running and inserting records in all
tables from the 3 groups. It uses one connection to insert records
in A, one connection to insert records in B, one connection to
insert records in C and one connection to delete the old records
from A, B and C. It also has several connections to query the
database but this only happens when a client is connected to the
aplication. At the end of the day this aplications does a backup of
the database. It closes all opened connections, shutdow the
database, copy the database file, open the database and validate the
copy.
2) This aplication runs once a week and uses only tables in group A.
It has a list of files in disk and tests the tables to see if the
files (path) exist in the database if not the aplication inserts the
records in the database. This has 16 simultaneous connections to the
database.
The statistics from a non corrupted database (this is one of the
databases that has more records ) are:
Database header page information:
Flags 0
Checksum 12345
Generation 1822942
Page size 4096
ODS version 10.1
Oldest transaction 1822898
Oldest active 1822899
Oldest snapshot 1822899
Next transaction 1822900
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 Jun 7, 2005 12:36:38
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
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 ...
APPLICATIONS (128)
Primary pointer page: 163, Index root page: 164
Data pages: 1, data page slots: 1, average fill: 16%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_APPLICATIONS (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
Index UNQ_APPLICATIONS (1)
Depth: 1, leaf buckets: 1, nodes: 10
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
APPLICATION_PROPERTIES (129)
Primary pointer page: 165, Index root page: 166
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_APPLICATION_PROPERTIES (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 18.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CAMERAS (130)
Primary pointer page: 167, Index root page: 168
Data pages: 1, data page slots: 1, average fill: 15%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_CAMERAS (0)
Depth: 1, leaf buckets: 1, nodes: 16
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
COMPLEX_EVENT (131)
Primary pointer page: 170, Index root page: 171
Data pages: 2856, data page slots: 2856, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2855
Index FK_COMPLEX_EVENT_CAM (1)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index FK_COMPLEX_EVENT_SERVER (2)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index FK_COMPLEX_EVENT_STATION (3)
Depth: 2, leaf buckets: 136, nodes: 73887
Average data length: 0.00, total dup: 73872, max dup: 10588
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 47
60 - 79% = 5
80 - 99% = 83
Index FK_COMPLEX_EVENT_TYPE (4)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index PK_COMPLEX_EVENT (0)
Depth: 2, leaf buckets: 136, nodes: 73887
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 132
DAY_RECORDING_TRACE (132)
Primary pointer page: 173, Index root page: 174
Data pages: 47, data page slots: 49, average fill: 79%
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 1
60 - 79% = 5
80 - 99% = 36
Index PK_DAY_RECORDING_TRACE (0)
Depth: 2, leaf buckets: 4, nodes: 1436
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
EMAILS (133)
Primary pointer page: 175, Index root page: 176
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_EMAILS (1)
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
Index PK_EMAILS (0)
Depth: 1, leaf buckets: 1, nodes: 1
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
EVENTS (134)
Primary pointer page: 180, Index root page: 181
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENTS (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
EVENT_PROPERTIES (135)
Primary pointer page: 182, Index root page: 183
Data pages: 1, data page slots: 1, average fill: 13%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENT_PROPERTIES (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
EVENT_TYPE (136)
Primary pointer page: 185, Index root page: 186
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENT_TYPE (0)
Depth: 1, leaf buckets: 1, nodes: 3
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 UNQ_EVENT_TYPE (1)
Depth: 1, leaf buckets: 1, nodes: 3
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
HOUR_RECORDING_TRACE (137)
Primary pointer page: 188, Index root page: 189
Data pages: 2186, data page slots: 2186, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 800
80 - 99% = 1384
Index PK_HOUR_RECORDING_TRACE (0)
Depth: 2, leaf buckets: 171, nodes: 85957
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 36
60 - 79% = 0
80 - 99% = 133
MALFUNCTIONS (138)
Primary pointer page: 192, Index root page: 193
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MALFUNCTIONS (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
MONTH_RECORDING_TRACE (139)
Primary pointer page: 194, Index root page: 195
Data pages: 6, data page slots: 8, average fill: 35%
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index PK_MONTH_RECORDING_TRACE (0)
Depth: 1, leaf buckets: 1, nodes: 61
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
OCCURRENCE (140)
Primary pointer page: 197, Index root page: 198
Data pages: 365, data page slots: 365, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 125
80 - 99% = 239
Index OCCURRENCE_PK (0)
Depth: 2, leaf buckets: 21, nodes: 11053
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 1
80 - 99% = 17
Index OCCURRENCE_TYPE_FK1 (1)
Depth: 2, leaf buckets: 20, nodes: 11053
Average data length: 0.00, total dup: 11038, max dup: 3898
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5
60 - 79% = 0
80 - 99% = 14
Index SERVERID_OCCURRENCE_FK1 (2)
Depth: 2, leaf buckets: 21, nodes: 11053
Average data length: 0.00, total dup: 11052, max dup: 11052
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 7
60 - 79% = 1
80 - 99% = 12
OCCURRENCE_CLASS (141)
Primary pointer page: 200, Index root page: 201
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_CLASS_PK (0)
Depth: 1, leaf buckets: 1, nodes: 3
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
OCCURRENCE_LEVEL (142)
Primary pointer page: 202, Index root page: 203
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_LEVEL_PK (0)
Depth: 1, leaf buckets: 1, nodes: 5
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
OCCURRENCE_TYPE (143)
Primary pointer page: 204, Index root page: 205
Data pages: 2, data page slots: 2, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index OCCURRENCE_CLASS_TYPE_FK1 (1)
Depth: 1, leaf buckets: 1, nodes: 54
Average data length: 0.00, total dup: 51, max dup: 28
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_LEVEL_TYPE_FK1 (2)
Depth: 1, leaf buckets: 1, nodes: 54
Average data length: 0.00, total dup: 49, max dup: 19
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_TYPE_PK (0)
Depth: 1, leaf buckets: 1, nodes: 54
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
OCCUR_EVENT_TYPE (144)
Primary pointer page: 206, Index root page: 207
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCCUR_EVENT_TYPE (1)
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
Index FK_OCCUR_EVENT_TYPE2 (2)
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
Index PK_OCCUR_EVENT_TYPE (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
OCC_TYPE_EMAIL (145)
Primary pointer page: 208, Index root page: 209
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCC_TYPE_EMAIL (1)
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
Index PK_OCC_TYPE_EMAIL (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
OCC_TYPE_ROLE (146)
Primary pointer page: 210, Index root page: 211
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCC_TYPE_ROLE (1)
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
Index FK_OCC_TYPE_ROLE2 (2)
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
Index PK_OCC_TYPE_ROLE (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
OLDESTIMAGES (147)
Primary pointer page: 212, Index root page: 213
Data pages: 11818, data page slots: 11818, average fill: 64%
Fill distribution:
0 - 19% = 7
20 - 39% = 62
40 - 59% = 1107
60 - 79% = 10642
80 - 99% = 0
Index PK_OLDESTIMAGES (0)
Depth: 3, leaf buckets: 2594, nodes: 716807
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 87
40 - 59% = 239
60 - 79% = 936
80 - 99% = 1332
PROPERTY_TYPES (148)
Primary pointer page: 214, Index root page: 215
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PROPERTY_TYPES (0)
Depth: 1, leaf buckets: 1, nodes: 3
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 UNQ_PROPERTY_TYPES (1)
Depth: 1, leaf buckets: 1, nodes: 3
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
RECORDING_TYPE (149)
Primary pointer page: 216, Index root page: 217
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY1 (0)
Depth: 1, leaf buckets: 1, nodes: 6
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
ROLES (150)
Primary pointer page: 218, Index root page: 219
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ROLES (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
SERVERID (151)
Primary pointer page: 220, Index root page: 221
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SERVERID (0)
Depth: 1, leaf buckets: 1, nodes: 2
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
SIGV_5_VIDEOCAM0 (155)
Primary pointer page: 229, Index root page: 230
Data pages: 1761, data page slots: 1761, average fill: 78%
Fill distribution:
0 - 19% = 27
20 - 39% = 7
40 - 59% = 1
60 - 79% = 1667
80 - 99% = 59
Index FK_SIGV_5_VIDEOCAM0 (3)
Depth: 2, leaf buckets: 124, nodes: 58858
Average data length: 0.00, total dup: 58855, max dup: 28033
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 72
60 - 79% = 4
80 - 99% = 48
Index RDB$PRIMARY2 (0)
Depth: 2, leaf buckets: 224, nodes: 58858
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 13
40 - 59% = 67
60 - 79% = 2
80 - 99% = 140
Index SIGV_5_VIDEOCAM0_IDX1 (2)
Depth: 3, leaf buckets: 388, nodes: 58858
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 212
60 - 79% = 2
80 - 99% = 173
Index UNQ_SIGV_5_VIDEOCAM0 (1)
Depth: 3, leaf buckets: 331, nodes: 58858
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 3
20 - 39% = 24
40 - 59% = 163
60 - 79% = 80
80 - 99% = 61
SIGV_5_VIDEOCAM1 (156)
Primary pointer page: 231, Index root page: 232
Data pages: 1665, data page slots: 1697, average fill: 63%
Fill distribution:
0 - 19% = 392
20 - 39% = 3
40 - 59% = 3
60 - 79% = 181
80 - 99% = 1086
Index FK_SIGV_5_VIDEOCAM1 (3)
Depth: 2, leaf buckets: 118, nodes: 42587
Average data length: 0.00, total dup: 42584, max dup: 34983
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 112
60 - 79% = 0
80 - 99% = 6
Index RDB$PRIMARY3 (0)
Depth: 2, leaf buckets: 217, nodes: 42587
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 172
60 - 79% = 1
80 - 99% = 43
Index SIGV_5_VIDEOCAM1_IDX1 (2)
Depth: 3, leaf buckets: 391, nodes: 42587
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 366
60 - 79% = 1
80 - 99% = 22
Index UNQ_SIGV_5_VIDEOCAM1 (1)
Depth: 3, leaf buckets: 269, nodes: 42587
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 34
40 - 59% = 139
60 - 79% = 37
80 - 99% = 44
SIGV_5_VIDEOCAM10 (157)
Primary pointer page: 235, Index root page: 236
Data pages: 672, data page slots: 682, average fill: 79%
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 666
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM10 (3)
Depth: 2, leaf buckets: 44, nodes: 22013
Average data length: 0.00, total dup: 22010, max dup: 12787
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 19
60 - 79% = 1
80 - 99% = 22
Index RDB$PRIMARY4 (0)
Depth: 2, leaf buckets: 82, nodes: 22013
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 27
60 - 79% = 1
80 - 99% = 53
Index SIGV_5_VIDEOCAM10_IDX1 (2)
Depth: 2, leaf buckets: 119, nodes: 22013
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 22
60 - 79% = 2
80 - 99% = 94
Index UNQ_SIGV_5_VIDEOCAM10 (1)
Depth: 2, leaf buckets: 141, nodes: 22013
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 18
40 - 59% = 68
60 - 79% = 39
80 - 99% = 15
SIGV_5_VIDEOCAM11 (158)
Primary pointer page: 237, Index root page: 238
Data pages: 871, data page slots: 889, average fill: 76%
Fill distribution:
0 - 19% = 36
20 - 39% = 3
40 - 59% = 1
60 - 79% = 829
80 - 99% = 2
Index FK_SIGV_5_VIDEOCAM11 (3)
Depth: 2, leaf buckets: 51, nodes: 27575
Average data length: 0.00, total dup: 27572, max dup: 17021
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 15
60 - 79% = 1
80 - 99% = 32
Index RDB$PRIMARY5 (0)
Depth: 2, leaf buckets: 86, nodes: 27575
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 1
60 - 79% = 0
80 - 99% = 83
Index SIGV_5_VIDEOCAM11_IDX1 (2)
Depth: 2, leaf buckets: 144, nodes: 27575
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 20
60 - 79% = 0
80 - 99% = 123
Index UNQ_SIGV_5_VIDEOCAM11 (1)
Depth: 2, leaf buckets: 170, nodes: 27575
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 3
20 - 39% = 28
40 - 59% = 62
60 - 79% = 58
80 - 99% = 19
SIGV_5_VIDEOCAM12 (159)
Primary pointer page: 240, Index root page: 241
Data pages: 1097, data page slots: 1106, average fill: 78%
Fill distribution:
0 - 19% = 21
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1076
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM12 (3)
Depth: 2, leaf buckets: 65, nodes: 35566
Average data length: 0.00, total dup: 35563, max dup: 20929
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 20
60 - 79% = 2
80 - 99% = 41
Index RDB$PRIMARY6 (0)
Depth: 2, leaf buckets: 109, nodes: 35566
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% = 108
Index SIGV_5_VIDEOCAM12_IDX1 (2)
Depth: 2, leaf buckets: 189, nodes: 35566
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 34
60 - 79% = 1
80 - 99% = 152
Index UNQ_SIGV_5_VIDEOCAM12 (1)
Depth: 2, leaf buckets: 198, nodes: 35566
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 17
40 - 59% = 82
60 - 79% = 59
80 - 99% = 38
SIGV_5_VIDEOCAM13 (160)
Primary pointer page: 242, Index root page: 243
Data pages: 1124, data page slots: 1133, average fill: 78%
Fill distribution:
0 - 19% = 20
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1103
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM13 (3)
Depth: 2, leaf buckets: 64, nodes: 36451
Average data length: 0.00, total dup: 36447, max dup: 23050
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 18
60 - 79% = 3
80 - 99% = 43
Index RDB$PRIMARY7 (0)
Depth: 2, leaf buckets: 112, nodes: 36451
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 110
Index SIGV_5_VIDEOCAM13_IDX1 (2)
Depth: 3, leaf buckets: 198, nodes: 36451
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 44
60 - 79% = 2
80 - 99% = 151
Index UNQ_SIGV_5_VIDEOCAM13 (1)
Depth: 2, leaf buckets: 213, nodes: 36451
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 15
40 - 59% = 108
60 - 79% = 58
80 - 99% = 30
SIGV_5_VIDEOCAM14 (161)
Primary pointer page: 245, Index root page: 246
Data pages: 941, data page slots: 941, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 940
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM14 (3)
Depth: 2, leaf buckets: 60, nodes: 31032
Average data length: 0.00, total dup: 31029, max dup: 15518
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 24
60 - 79% = 2
80 - 99% = 32
Index RDB$PRIMARY8 (0)
Depth: 2, leaf buckets: 107, nodes: 31032
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 24
60 - 79% = 1
80 - 99% = 82
Index SIGV_5_VIDEOCAM14_IDX1 (2)
Depth: 2, leaf buckets: 173, nodes: 31032
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 46
60 - 79% = 1
80 - 99% = 125
Index UNQ_SIGV_5_VIDEOCAM14 (1)
Depth: 2, leaf buckets: 179, nodes: 31032
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 99
60 - 79% = 58
80 - 99% = 15
SIGV_5_VIDEOCAM15 (162)
Primary pointer page: 248, Index root page: 249
Data pages: 949, data page slots: 951, average fill: 78%
Fill distribution:
0 - 19% = 17
20 - 39% = 2
40 - 59% = 1
60 - 79% = 927
80 - 99% = 2
Index FK_SIGV_5_VIDEOCAM15 (3)
Depth: 2, leaf buckets: 57, nodes: 30751
Average data length: 0.00, total dup: 30748, max dup: 16909
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 21
60 - 79% = 1
80 - 99% = 34
Index RDB$PRIMARY9 (0)
Depth: 2, leaf buckets: 94, nodes: 30751
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 93
Index SIGV_5_VIDEOCAM15_IDX1 (2)
Depth: 2, leaf buckets: 170, nodes: 30751
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 43
60 - 79% = 0
80 - 99% = 126
Index UNQ_SIGV_5_VIDEOCAM15 (1)
Depth: 2, leaf buckets: 188, nodes: 30751
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 108
60 - 79% = 58
80 - 99% = 12
SIGV_5_VIDEOCAM2 (163)
Primary pointer page: 250, Index root page: 251
Data pages: 3462, data page slots: 3462, average fill: 79%
Fill distribution:
0 - 19% = 54
20 - 39% = 15
40 - 59% = 3
60 - 79% = 865
80 - 99% = 2525
Index FK_SIGV_5_VIDEOCAM2 (3)
Depth: 2, leaf buckets: 289, nodes: 112341
Average data length: 0.00, total dup: 112338, max dup: 62485
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 246
60 - 79% = 1
80 - 99% = 40
Index RDB$PRIMARY10 (0)
Depth: 3, leaf buckets: 633, nodes: 112341
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 507
60 - 79% = 4
80 - 99% = 73
Index SIGV_5_VIDEOCAM2_IDX1 (2)
Depth: 3, leaf buckets: 905, nodes: 112341
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 738
60 - 79% = 3
80 - 99% = 163
Index UNQ_SIGV_5_VIDEOCAM2 (1)
Depth: 3, leaf buckets: 698, nodes: 112341
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 29
20 - 39% = 32
40 - 59% = 487
60 - 79% = 42
80 - 99% = 108
SIGV_5_VIDEOCAM3 (164)
Primary pointer page: 252, Index root page: 253
Data pages: 1445, data page slots: 1475, average fill: 75%
Fill distribution:
0 - 19% = 88
20 - 39% = 2
40 - 59% = 5
60 - 79% = 1077
80 - 99% = 273
Index FK_SIGV_5_VIDEOCAM3 (3)
Depth: 2, leaf buckets: 98, nodes: 44888
Average data length: 0.00, total dup: 44885, max dup: 31145
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 57
60 - 79% = 3
80 - 99% = 35
Index RDB$PRIMARY11 (0)
Depth: 2, leaf buckets: 139, nodes: 44888
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 0
60 - 79% = 1
80 - 99% = 134
Index SIGV_5_VIDEOCAM3_IDX1 (2)
Depth: 3, leaf buckets: 297, nodes: 44888
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 161
60 - 79% = 0
80 - 99% = 134
Index UNQ_SIGV_5_VIDEOCAM3 (1)
Depth: 3, leaf buckets: 264, nodes: 44888
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 16
20 - 39% = 36
40 - 59% = 93
60 - 79% = 57
80 - 99% = 62
SIGV_5_VIDEOCAM4 (165)
Primary pointer page: 257, Index root page: 258
Data pages: 2571, data page slots: 2571, average fill: 79%
Fill distribution:
0 - 19% = 4
20 - 39% = 50
40 - 59% = 1
60 - 79% = 1097
80 - 99% = 1419
Index FK_SIGV_5_VIDEOCAM4 (3)
Depth: 2, leaf buckets: 189, nodes: 83617
Average data length: 0.00, total dup: 83614, max dup: 46523
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 131
60 - 79% = 3
80 - 99% = 55
Index RDB$PRIMARY12 (0)
Depth: 3, leaf buckets: 377, nodes: 83617
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 10
40 - 59% = 228
60 - 79% = 1
80 - 99% = 137
Index SIGV_5_VIDEOCAM4_IDX1 (2)
Depth: 3, leaf buckets: 592, nodes: 83617
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 386
60 - 79% = 2
80 - 99% = 203
Index UNQ_SIGV_5_VIDEOCAM4 (1)
Depth: 3, leaf buckets: 496, nodes: 83617
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 5
20 - 39% = 25
40 - 59% = 293
60 - 79% = 111
80 - 99% = 62
SIGV_5_VIDEOCAM5 (166)
Primary pointer page: 259, Index root page: 260
Data pages: 1069, data page slots: 1070, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1067
80 - 99% = 1
Index FK_SIGV_5_VIDEOCAM5 (3)
Depth: 2, leaf buckets: 67, nodes: 35258
Average data length: 0.00, total dup: 35256, max dup: 18169
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 28
60 - 79% = 2
80 - 99% = 37
Index RDB$PRIMARY13 (0)
Depth: 2, leaf buckets: 111, nodes: 35258
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5
60 - 79% = 1
80 - 99% = 104
Index SIGV_5_VIDEOCAM5_IDX1 (2)
Depth: 3, leaf buckets: 200, nodes: 35258
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 59
60 - 79% = 2
80 - 99% = 138
Index UNQ_SIGV_5_VIDEOCAM5 (1)
Depth: 2, leaf buckets: 197, nodes: 35258
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 97
60 - 79% = 45
80 - 99% = 45
SIGV_5_VIDEOCAM6 (167)
Primary pointer page: 261, Index root page: 262
Data pages: 635, data page slots: 660, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 632
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM6 (3)
Depth: 2, leaf buckets: 37, nodes: 20897
Average data length: 0.00, total dup: 20894, max dup: 13319
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10
60 - 79% = 0
80 - 99% = 26
Index RDB$PRIMARY14 (0)
Depth: 2, leaf buckets: 76, nodes: 20897
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 21
60 - 79% = 0
80 - 99% = 53
Index SIGV_5_VIDEOCAM6_IDX1 (2)
Depth: 2, leaf buckets: 113, nodes: 20897
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 21
60 - 79% = 2
80 - 99% = 89
Index UNQ_SIGV_5_VIDEOCAM6 (1)
Depth: 2, leaf buckets: 131, nodes: 20897
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 55
60 - 79% = 30
80 - 99% = 21
SIGV_5_VIDEOCAM7 (168)
Primary pointer page: 265, Index root page: 266
Data pages: 1776, data page slots: 1776, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 1
60 - 79% = 1648
80 - 99% = 122
Index FK_SIGV_5_VIDEOCAM7 (3)
Depth: 2, leaf buckets: 110, nodes: 58480
Average data length: 0.00, total dup: 58477, max dup: 24422
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 44
60 - 79% = 2
80 - 99% = 63
Index RDB$PRIMARY15 (0)
Depth: 2, leaf buckets: 189, nodes: 58480
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 2
60 - 79% = 1
80 - 99% = 172
Index SIGV_5_VIDEOCAM7_IDX1 (2)
Depth: 3, leaf buckets: 318, nodes: 58480
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 78
60 - 79% = 2
80 - 99% = 237
Index UNQ_SIGV_5_VIDEOCAM7 (1)
Depth: 3, leaf buckets: 275, nodes: 58480
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 105
60 - 79% = 40
80 - 99% = 124
SIGV_5_VIDEOCAM8 (169)
Primary pointer page: 267, Index root page: 268
Data pages: 1745, data page slots: 1751, average fill: 72%
Fill distribution:
0 - 19% = 139
20 - 39% = 72
40 - 59% = 0
60 - 79% = 407
80 - 99% = 1127
Index FK_SIGV_5_VIDEOCAM8 (3)
Depth: 2, leaf buckets: 120, nodes: 51918
Average data length: 0.00, total dup: 51915, max dup: 29698
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 82
60 - 79% = 2
80 - 99% = 33
Index RDB$PRIMARY16 (0)
Depth: 2, leaf buckets: 241, nodes: 51918
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 156
60 - 79% = 4
80 - 99% = 77
Index SIGV_5_VIDEOCAM8_IDX1 (2)
Depth: 3, leaf buckets: 376, nodes: 51918
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 251
60 - 79% = 2
80 - 99% = 121
Index UNQ_SIGV_5_VIDEOCAM8 (1)
Depth: 3, leaf buckets: 300, nodes: 51918
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 6
20 - 39% = 24
40 - 59% = 121
60 - 79% = 118
80 - 99% = 31
SIGV_5_VIDEOCAM9 (170)
Primary pointer page: 271, Index root page: 272
Data pages: 745, data page slots: 745, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 739
80 - 99% = 4
Index FK_SIGV_5_VIDEOCAM9 (3)
Depth: 2, leaf buckets: 47, nodes: 24535
Average data length: 0.00, total dup: 24532, max dup: 13887
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 18
60 - 79% = 2
80 - 99% = 26
Index RDB$PRIMARY17 (0)
Depth: 2, leaf buckets: 94, nodes: 24535
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 34
60 - 79% = 1
80 - 99% = 57
Index SIGV_5_VIDEOCAM9_IDX1 (2)
Depth: 2, leaf buckets: 135, nodes: 24535
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 30
60 - 79% = 0
80 - 99% = 103
Index UNQ_SIGV_5_VIDEOCAM9 (1)
Depth: 2, leaf buckets: 156, nodes: 24535
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 95
60 - 79% = 49
80 - 99% = 0
SIMPLE_EVENT (152)
Primary pointer page: 223, Index root page: 224
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_SIMPLE_EVENT (1)
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
Index FK_SIMPLE_EVENT_SERVER_ID (2)
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
Index FK_SIMPLE_EVENT_TYPE (3)
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
Index PK_SIMPLE_EVENT (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
STATION (153)
Primary pointer page: 225, Index root page: 226
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_STATION (0)
Depth: 1, leaf buckets: 1, nodes: 16
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 STATION_IDX1 (2)
Depth: 1, leaf buckets: 1, nodes: 16
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 UNQ_STATION (1)
Depth: 1, leaf buckets: 1, nodes: 16
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
STATION_CAMERAS (154)
Primary pointer page: 227, Index root page: 228
Data pages: 1, data page slots: 1, average fill: 11%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_STATION_CAMERA (1)
Depth: 1, leaf buckets: 1, nodes: 16
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 FK_STATION_STATION (2)
Depth: 1, leaf buckets: 1, nodes: 16
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 PK_STATION_CAMERAS (0)
Depth: 1, leaf buckets: 1, nodes: 16
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
If you need more information please tell me.
Thanks for the help.
Elisabete
wrote:
> > Hellomachine
> >
> > I have Firebird SuperServer 1.5 installed in a dual processor
> > with Windows 2000 Server. The CPU affinity is set to 1.sometimes
> >
> > I have two separated processes accessing the database and
> > when one of the processes crashs the database file grows from150Mb to
> > 1Gb and the result file is corrupted. Each process has 16connections
> > opened to the database in different threads.happens
> > This problem does not happen in all machines.
> >
> > Do you have any ideia why this happen? Because each time this
> > I loose all data.and see if
> >
> > Thanks in advanced.
> >
> > Elisabete
>
> do you have forced writes on this db set to ON? if not then do it
> you get the same result. I would think not.to tell
> IF you do have forced writes set to ON, then I think you will need
> us more about whta these processes are doing. If it's always thesame
> process which crashes, then let's talk more about that one.processes
> When it crashes, do you still see CPU activity running on that
> process/thread?
> The process whcih crashes, is it dealing with inserts? or are all
> only selects?I have forced writes ON and it is not always the same process that
> You can see there are is a lot more info to provide.
> Alan
crashes. For the logs that my aplications write I can see that the
processes are not crashing because of the database but when this
happens the connections to the database are oppened and most of the
times inserting records.
The database has 43 tables. This tables are divided in 3 logical
groups (A, B and C). The tables in this groups are not related in
the database, this means that inserting in a table of A does not
afect the B or C tables.
The configuration of this aplications is as foillows:
1) This aplication is always running and inserting records in all
tables from the 3 groups. It uses one connection to insert records
in A, one connection to insert records in B, one connection to
insert records in C and one connection to delete the old records
from A, B and C. It also has several connections to query the
database but this only happens when a client is connected to the
aplication. At the end of the day this aplications does a backup of
the database. It closes all opened connections, shutdow the
database, copy the database file, open the database and validate the
copy.
2) This aplication runs once a week and uses only tables in group A.
It has a list of files in disk and tests the tables to see if the
files (path) exist in the database if not the aplication inserts the
records in the database. This has 16 simultaneous connections to the
database.
The statistics from a non corrupted database (this is one of the
databases that has more records ) are:
Database header page information:
Flags 0
Checksum 12345
Generation 1822942
Page size 4096
ODS version 10.1
Oldest transaction 1822898
Oldest active 1822899
Oldest snapshot 1822899
Next transaction 1822900
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 Jun 7, 2005 12:36:38
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
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 ...
APPLICATIONS (128)
Primary pointer page: 163, Index root page: 164
Data pages: 1, data page slots: 1, average fill: 16%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_APPLICATIONS (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
Index UNQ_APPLICATIONS (1)
Depth: 1, leaf buckets: 1, nodes: 10
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
APPLICATION_PROPERTIES (129)
Primary pointer page: 165, Index root page: 166
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_APPLICATION_PROPERTIES (0)
Depth: 1, leaf buckets: 1, nodes: 3
Average data length: 18.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
CAMERAS (130)
Primary pointer page: 167, Index root page: 168
Data pages: 1, data page slots: 1, average fill: 15%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_CAMERAS (0)
Depth: 1, leaf buckets: 1, nodes: 16
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
COMPLEX_EVENT (131)
Primary pointer page: 170, Index root page: 171
Data pages: 2856, data page slots: 2856, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 2855
Index FK_COMPLEX_EVENT_CAM (1)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index FK_COMPLEX_EVENT_SERVER (2)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index FK_COMPLEX_EVENT_STATION (3)
Depth: 2, leaf buckets: 136, nodes: 73887
Average data length: 0.00, total dup: 73872, max dup: 10588
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 47
60 - 79% = 5
80 - 99% = 83
Index FK_COMPLEX_EVENT_TYPE (4)
Depth: 2, leaf buckets: 130, nodes: 73887
Average data length: 0.00, total dup: 73886, max dup: 73886
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 39
60 - 79% = 1
80 - 99% = 89
Index PK_COMPLEX_EVENT (0)
Depth: 2, leaf buckets: 136, nodes: 73887
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 0
80 - 99% = 132
DAY_RECORDING_TRACE (132)
Primary pointer page: 173, Index root page: 174
Data pages: 47, data page slots: 49, average fill: 79%
Fill distribution:
0 - 19% = 3
20 - 39% = 2
40 - 59% = 1
60 - 79% = 5
80 - 99% = 36
Index PK_DAY_RECORDING_TRACE (0)
Depth: 2, leaf buckets: 4, nodes: 1436
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
EMAILS (133)
Primary pointer page: 175, Index root page: 176
Data pages: 1, data page slots: 1, average fill: 2%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_EMAILS (1)
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
Index PK_EMAILS (0)
Depth: 1, leaf buckets: 1, nodes: 1
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
EVENTS (134)
Primary pointer page: 180, Index root page: 181
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENTS (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
EVENT_PROPERTIES (135)
Primary pointer page: 182, Index root page: 183
Data pages: 1, data page slots: 1, average fill: 13%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENT_PROPERTIES (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 14.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
EVENT_TYPE (136)
Primary pointer page: 185, Index root page: 186
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_EVENT_TYPE (0)
Depth: 1, leaf buckets: 1, nodes: 3
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 UNQ_EVENT_TYPE (1)
Depth: 1, leaf buckets: 1, nodes: 3
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
HOUR_RECORDING_TRACE (137)
Primary pointer page: 188, Index root page: 189
Data pages: 2186, data page slots: 2186, average fill: 84%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 800
80 - 99% = 1384
Index PK_HOUR_RECORDING_TRACE (0)
Depth: 2, leaf buckets: 171, nodes: 85957
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 36
60 - 79% = 0
80 - 99% = 133
MALFUNCTIONS (138)
Primary pointer page: 192, Index root page: 193
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_MALFUNCTIONS (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
MONTH_RECORDING_TRACE (139)
Primary pointer page: 194, Index root page: 195
Data pages: 6, data page slots: 8, average fill: 35%
Fill distribution:
0 - 19% = 2
20 - 39% = 2
40 - 59% = 1
60 - 79% = 1
80 - 99% = 0
Index PK_MONTH_RECORDING_TRACE (0)
Depth: 1, leaf buckets: 1, nodes: 61
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
OCCURRENCE (140)
Primary pointer page: 197, Index root page: 198
Data pages: 365, data page slots: 365, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 125
80 - 99% = 239
Index OCCURRENCE_PK (0)
Depth: 2, leaf buckets: 21, nodes: 11053
Average data length: 1.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 1
80 - 99% = 17
Index OCCURRENCE_TYPE_FK1 (1)
Depth: 2, leaf buckets: 20, nodes: 11053
Average data length: 0.00, total dup: 11038, max dup: 3898
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 5
60 - 79% = 0
80 - 99% = 14
Index SERVERID_OCCURRENCE_FK1 (2)
Depth: 2, leaf buckets: 21, nodes: 11053
Average data length: 0.00, total dup: 11052, max dup: 11052
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 7
60 - 79% = 1
80 - 99% = 12
OCCURRENCE_CLASS (141)
Primary pointer page: 200, Index root page: 201
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_CLASS_PK (0)
Depth: 1, leaf buckets: 1, nodes: 3
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
OCCURRENCE_LEVEL (142)
Primary pointer page: 202, Index root page: 203
Data pages: 1, data page slots: 1, average fill: 5%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_LEVEL_PK (0)
Depth: 1, leaf buckets: 1, nodes: 5
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
OCCURRENCE_TYPE (143)
Primary pointer page: 204, Index root page: 205
Data pages: 2, data page slots: 2, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index OCCURRENCE_CLASS_TYPE_FK1 (1)
Depth: 1, leaf buckets: 1, nodes: 54
Average data length: 0.00, total dup: 51, max dup: 28
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_LEVEL_TYPE_FK1 (2)
Depth: 1, leaf buckets: 1, nodes: 54
Average data length: 0.00, total dup: 49, max dup: 19
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index OCCURRENCE_TYPE_PK (0)
Depth: 1, leaf buckets: 1, nodes: 54
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
OCCUR_EVENT_TYPE (144)
Primary pointer page: 206, Index root page: 207
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCCUR_EVENT_TYPE (1)
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
Index FK_OCCUR_EVENT_TYPE2 (2)
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
Index PK_OCCUR_EVENT_TYPE (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
OCC_TYPE_EMAIL (145)
Primary pointer page: 208, Index root page: 209
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCC_TYPE_EMAIL (1)
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
Index PK_OCC_TYPE_EMAIL (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
OCC_TYPE_ROLE (146)
Primary pointer page: 210, Index root page: 211
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_OCC_TYPE_ROLE (1)
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
Index FK_OCC_TYPE_ROLE2 (2)
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
Index PK_OCC_TYPE_ROLE (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
OLDESTIMAGES (147)
Primary pointer page: 212, Index root page: 213
Data pages: 11818, data page slots: 11818, average fill: 64%
Fill distribution:
0 - 19% = 7
20 - 39% = 62
40 - 59% = 1107
60 - 79% = 10642
80 - 99% = 0
Index PK_OLDESTIMAGES (0)
Depth: 3, leaf buckets: 2594, nodes: 716807
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 87
40 - 59% = 239
60 - 79% = 936
80 - 99% = 1332
PROPERTY_TYPES (148)
Primary pointer page: 214, Index root page: 215
Data pages: 1, data page slots: 1, average fill: 3%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_PROPERTY_TYPES (0)
Depth: 1, leaf buckets: 1, nodes: 3
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 UNQ_PROPERTY_TYPES (1)
Depth: 1, leaf buckets: 1, nodes: 3
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
RECORDING_TYPE (149)
Primary pointer page: 216, Index root page: 217
Data pages: 1, data page slots: 1, average fill: 6%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index RDB$PRIMARY1 (0)
Depth: 1, leaf buckets: 1, nodes: 6
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
ROLES (150)
Primary pointer page: 218, Index root page: 219
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ROLES (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
SERVERID (151)
Primary pointer page: 220, Index root page: 221
Data pages: 1, data page slots: 1, average fill: 4%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_SERVERID (0)
Depth: 1, leaf buckets: 1, nodes: 2
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
SIGV_5_VIDEOCAM0 (155)
Primary pointer page: 229, Index root page: 230
Data pages: 1761, data page slots: 1761, average fill: 78%
Fill distribution:
0 - 19% = 27
20 - 39% = 7
40 - 59% = 1
60 - 79% = 1667
80 - 99% = 59
Index FK_SIGV_5_VIDEOCAM0 (3)
Depth: 2, leaf buckets: 124, nodes: 58858
Average data length: 0.00, total dup: 58855, max dup: 28033
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 72
60 - 79% = 4
80 - 99% = 48
Index RDB$PRIMARY2 (0)
Depth: 2, leaf buckets: 224, nodes: 58858
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 13
40 - 59% = 67
60 - 79% = 2
80 - 99% = 140
Index SIGV_5_VIDEOCAM0_IDX1 (2)
Depth: 3, leaf buckets: 388, nodes: 58858
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 212
60 - 79% = 2
80 - 99% = 173
Index UNQ_SIGV_5_VIDEOCAM0 (1)
Depth: 3, leaf buckets: 331, nodes: 58858
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 3
20 - 39% = 24
40 - 59% = 163
60 - 79% = 80
80 - 99% = 61
SIGV_5_VIDEOCAM1 (156)
Primary pointer page: 231, Index root page: 232
Data pages: 1665, data page slots: 1697, average fill: 63%
Fill distribution:
0 - 19% = 392
20 - 39% = 3
40 - 59% = 3
60 - 79% = 181
80 - 99% = 1086
Index FK_SIGV_5_VIDEOCAM1 (3)
Depth: 2, leaf buckets: 118, nodes: 42587
Average data length: 0.00, total dup: 42584, max dup: 34983
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 112
60 - 79% = 0
80 - 99% = 6
Index RDB$PRIMARY3 (0)
Depth: 2, leaf buckets: 217, nodes: 42587
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 172
60 - 79% = 1
80 - 99% = 43
Index SIGV_5_VIDEOCAM1_IDX1 (2)
Depth: 3, leaf buckets: 391, nodes: 42587
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 366
60 - 79% = 1
80 - 99% = 22
Index UNQ_SIGV_5_VIDEOCAM1 (1)
Depth: 3, leaf buckets: 269, nodes: 42587
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 15
20 - 39% = 34
40 - 59% = 139
60 - 79% = 37
80 - 99% = 44
SIGV_5_VIDEOCAM10 (157)
Primary pointer page: 235, Index root page: 236
Data pages: 672, data page slots: 682, average fill: 79%
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 1
60 - 79% = 666
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM10 (3)
Depth: 2, leaf buckets: 44, nodes: 22013
Average data length: 0.00, total dup: 22010, max dup: 12787
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 19
60 - 79% = 1
80 - 99% = 22
Index RDB$PRIMARY4 (0)
Depth: 2, leaf buckets: 82, nodes: 22013
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 27
60 - 79% = 1
80 - 99% = 53
Index SIGV_5_VIDEOCAM10_IDX1 (2)
Depth: 2, leaf buckets: 119, nodes: 22013
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 22
60 - 79% = 2
80 - 99% = 94
Index UNQ_SIGV_5_VIDEOCAM10 (1)
Depth: 2, leaf buckets: 141, nodes: 22013
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 18
40 - 59% = 68
60 - 79% = 39
80 - 99% = 15
SIGV_5_VIDEOCAM11 (158)
Primary pointer page: 237, Index root page: 238
Data pages: 871, data page slots: 889, average fill: 76%
Fill distribution:
0 - 19% = 36
20 - 39% = 3
40 - 59% = 1
60 - 79% = 829
80 - 99% = 2
Index FK_SIGV_5_VIDEOCAM11 (3)
Depth: 2, leaf buckets: 51, nodes: 27575
Average data length: 0.00, total dup: 27572, max dup: 17021
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 15
60 - 79% = 1
80 - 99% = 32
Index RDB$PRIMARY5 (0)
Depth: 2, leaf buckets: 86, nodes: 27575
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 1
60 - 79% = 0
80 - 99% = 83
Index SIGV_5_VIDEOCAM11_IDX1 (2)
Depth: 2, leaf buckets: 144, nodes: 27575
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 20
60 - 79% = 0
80 - 99% = 123
Index UNQ_SIGV_5_VIDEOCAM11 (1)
Depth: 2, leaf buckets: 170, nodes: 27575
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 3
20 - 39% = 28
40 - 59% = 62
60 - 79% = 58
80 - 99% = 19
SIGV_5_VIDEOCAM12 (159)
Primary pointer page: 240, Index root page: 241
Data pages: 1097, data page slots: 1106, average fill: 78%
Fill distribution:
0 - 19% = 21
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1076
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM12 (3)
Depth: 2, leaf buckets: 65, nodes: 35566
Average data length: 0.00, total dup: 35563, max dup: 20929
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 20
60 - 79% = 2
80 - 99% = 41
Index RDB$PRIMARY6 (0)
Depth: 2, leaf buckets: 109, nodes: 35566
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% = 108
Index SIGV_5_VIDEOCAM12_IDX1 (2)
Depth: 2, leaf buckets: 189, nodes: 35566
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 34
60 - 79% = 1
80 - 99% = 152
Index UNQ_SIGV_5_VIDEOCAM12 (1)
Depth: 2, leaf buckets: 198, nodes: 35566
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 17
40 - 59% = 82
60 - 79% = 59
80 - 99% = 38
SIGV_5_VIDEOCAM13 (160)
Primary pointer page: 242, Index root page: 243
Data pages: 1124, data page slots: 1133, average fill: 78%
Fill distribution:
0 - 19% = 20
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1103
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM13 (3)
Depth: 2, leaf buckets: 64, nodes: 36451
Average data length: 0.00, total dup: 36447, max dup: 23050
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 18
60 - 79% = 3
80 - 99% = 43
Index RDB$PRIMARY7 (0)
Depth: 2, leaf buckets: 112, nodes: 36451
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 110
Index SIGV_5_VIDEOCAM13_IDX1 (2)
Depth: 3, leaf buckets: 198, nodes: 36451
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 44
60 - 79% = 2
80 - 99% = 151
Index UNQ_SIGV_5_VIDEOCAM13 (1)
Depth: 2, leaf buckets: 213, nodes: 36451
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 15
40 - 59% = 108
60 - 79% = 58
80 - 99% = 30
SIGV_5_VIDEOCAM14 (161)
Primary pointer page: 245, Index root page: 246
Data pages: 941, data page slots: 941, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 940
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM14 (3)
Depth: 2, leaf buckets: 60, nodes: 31032
Average data length: 0.00, total dup: 31029, max dup: 15518
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 24
60 - 79% = 2
80 - 99% = 32
Index RDB$PRIMARY8 (0)
Depth: 2, leaf buckets: 107, nodes: 31032
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 24
60 - 79% = 1
80 - 99% = 82
Index SIGV_5_VIDEOCAM14_IDX1 (2)
Depth: 2, leaf buckets: 173, nodes: 31032
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 46
60 - 79% = 1
80 - 99% = 125
Index UNQ_SIGV_5_VIDEOCAM14 (1)
Depth: 2, leaf buckets: 179, nodes: 31032
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 7
40 - 59% = 99
60 - 79% = 58
80 - 99% = 15
SIGV_5_VIDEOCAM15 (162)
Primary pointer page: 248, Index root page: 249
Data pages: 949, data page slots: 951, average fill: 78%
Fill distribution:
0 - 19% = 17
20 - 39% = 2
40 - 59% = 1
60 - 79% = 927
80 - 99% = 2
Index FK_SIGV_5_VIDEOCAM15 (3)
Depth: 2, leaf buckets: 57, nodes: 30751
Average data length: 0.00, total dup: 30748, max dup: 16909
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 21
60 - 79% = 1
80 - 99% = 34
Index RDB$PRIMARY9 (0)
Depth: 2, leaf buckets: 94, nodes: 30751
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 93
Index SIGV_5_VIDEOCAM15_IDX1 (2)
Depth: 2, leaf buckets: 170, nodes: 30751
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 43
60 - 79% = 0
80 - 99% = 126
Index UNQ_SIGV_5_VIDEOCAM15 (1)
Depth: 2, leaf buckets: 188, nodes: 30751
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 108
60 - 79% = 58
80 - 99% = 12
SIGV_5_VIDEOCAM2 (163)
Primary pointer page: 250, Index root page: 251
Data pages: 3462, data page slots: 3462, average fill: 79%
Fill distribution:
0 - 19% = 54
20 - 39% = 15
40 - 59% = 3
60 - 79% = 865
80 - 99% = 2525
Index FK_SIGV_5_VIDEOCAM2 (3)
Depth: 2, leaf buckets: 289, nodes: 112341
Average data length: 0.00, total dup: 112338, max dup: 62485
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 246
60 - 79% = 1
80 - 99% = 40
Index RDB$PRIMARY10 (0)
Depth: 3, leaf buckets: 633, nodes: 112341
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 48
40 - 59% = 507
60 - 79% = 4
80 - 99% = 73
Index SIGV_5_VIDEOCAM2_IDX1 (2)
Depth: 3, leaf buckets: 905, nodes: 112341
Average data length: 12.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 738
60 - 79% = 3
80 - 99% = 163
Index UNQ_SIGV_5_VIDEOCAM2 (1)
Depth: 3, leaf buckets: 698, nodes: 112341
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 29
20 - 39% = 32
40 - 59% = 487
60 - 79% = 42
80 - 99% = 108
SIGV_5_VIDEOCAM3 (164)
Primary pointer page: 252, Index root page: 253
Data pages: 1445, data page slots: 1475, average fill: 75%
Fill distribution:
0 - 19% = 88
20 - 39% = 2
40 - 59% = 5
60 - 79% = 1077
80 - 99% = 273
Index FK_SIGV_5_VIDEOCAM3 (3)
Depth: 2, leaf buckets: 98, nodes: 44888
Average data length: 0.00, total dup: 44885, max dup: 31145
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 57
60 - 79% = 3
80 - 99% = 35
Index RDB$PRIMARY11 (0)
Depth: 2, leaf buckets: 139, nodes: 44888
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 0
60 - 79% = 1
80 - 99% = 134
Index SIGV_5_VIDEOCAM3_IDX1 (2)
Depth: 3, leaf buckets: 297, nodes: 44888
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 161
60 - 79% = 0
80 - 99% = 134
Index UNQ_SIGV_5_VIDEOCAM3 (1)
Depth: 3, leaf buckets: 264, nodes: 44888
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 16
20 - 39% = 36
40 - 59% = 93
60 - 79% = 57
80 - 99% = 62
SIGV_5_VIDEOCAM4 (165)
Primary pointer page: 257, Index root page: 258
Data pages: 2571, data page slots: 2571, average fill: 79%
Fill distribution:
0 - 19% = 4
20 - 39% = 50
40 - 59% = 1
60 - 79% = 1097
80 - 99% = 1419
Index FK_SIGV_5_VIDEOCAM4 (3)
Depth: 2, leaf buckets: 189, nodes: 83617
Average data length: 0.00, total dup: 83614, max dup: 46523
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 131
60 - 79% = 3
80 - 99% = 55
Index RDB$PRIMARY12 (0)
Depth: 3, leaf buckets: 377, nodes: 83617
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 10
40 - 59% = 228
60 - 79% = 1
80 - 99% = 137
Index SIGV_5_VIDEOCAM4_IDX1 (2)
Depth: 3, leaf buckets: 592, nodes: 83617
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 386
60 - 79% = 2
80 - 99% = 203
Index UNQ_SIGV_5_VIDEOCAM4 (1)
Depth: 3, leaf buckets: 496, nodes: 83617
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 5
20 - 39% = 25
40 - 59% = 293
60 - 79% = 111
80 - 99% = 62
SIGV_5_VIDEOCAM5 (166)
Primary pointer page: 259, Index root page: 260
Data pages: 1069, data page slots: 1070, average fill: 79%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1067
80 - 99% = 1
Index FK_SIGV_5_VIDEOCAM5 (3)
Depth: 2, leaf buckets: 67, nodes: 35258
Average data length: 0.00, total dup: 35256, max dup: 18169
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 28
60 - 79% = 2
80 - 99% = 37
Index RDB$PRIMARY13 (0)
Depth: 2, leaf buckets: 111, nodes: 35258
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 5
60 - 79% = 1
80 - 99% = 104
Index SIGV_5_VIDEOCAM5_IDX1 (2)
Depth: 3, leaf buckets: 200, nodes: 35258
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 59
60 - 79% = 2
80 - 99% = 138
Index UNQ_SIGV_5_VIDEOCAM5 (1)
Depth: 2, leaf buckets: 197, nodes: 35258
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 9
40 - 59% = 97
60 - 79% = 45
80 - 99% = 45
SIGV_5_VIDEOCAM6 (167)
Primary pointer page: 261, Index root page: 262
Data pages: 635, data page slots: 660, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 632
80 - 99% = 0
Index FK_SIGV_5_VIDEOCAM6 (3)
Depth: 2, leaf buckets: 37, nodes: 20897
Average data length: 0.00, total dup: 20894, max dup: 13319
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 10
60 - 79% = 0
80 - 99% = 26
Index RDB$PRIMARY14 (0)
Depth: 2, leaf buckets: 76, nodes: 20897
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 2
40 - 59% = 21
60 - 79% = 0
80 - 99% = 53
Index SIGV_5_VIDEOCAM6_IDX1 (2)
Depth: 2, leaf buckets: 113, nodes: 20897
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 21
60 - 79% = 2
80 - 99% = 89
Index UNQ_SIGV_5_VIDEOCAM6 (1)
Depth: 2, leaf buckets: 131, nodes: 20897
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 24
40 - 59% = 55
60 - 79% = 30
80 - 99% = 21
SIGV_5_VIDEOCAM7 (168)
Primary pointer page: 265, Index root page: 266
Data pages: 1776, data page slots: 1776, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 4
40 - 59% = 1
60 - 79% = 1648
80 - 99% = 122
Index FK_SIGV_5_VIDEOCAM7 (3)
Depth: 2, leaf buckets: 110, nodes: 58480
Average data length: 0.00, total dup: 58477, max dup: 24422
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 44
60 - 79% = 2
80 - 99% = 63
Index RDB$PRIMARY15 (0)
Depth: 2, leaf buckets: 189, nodes: 58480
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 14
40 - 59% = 2
60 - 79% = 1
80 - 99% = 172
Index SIGV_5_VIDEOCAM7_IDX1 (2)
Depth: 3, leaf buckets: 318, nodes: 58480
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 78
60 - 79% = 2
80 - 99% = 237
Index UNQ_SIGV_5_VIDEOCAM7 (1)
Depth: 3, leaf buckets: 275, nodes: 58480
Average data length: 7.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 6
40 - 59% = 105
60 - 79% = 40
80 - 99% = 124
SIGV_5_VIDEOCAM8 (169)
Primary pointer page: 267, Index root page: 268
Data pages: 1745, data page slots: 1751, average fill: 72%
Fill distribution:
0 - 19% = 139
20 - 39% = 72
40 - 59% = 0
60 - 79% = 407
80 - 99% = 1127
Index FK_SIGV_5_VIDEOCAM8 (3)
Depth: 2, leaf buckets: 120, nodes: 51918
Average data length: 0.00, total dup: 51915, max dup: 29698
Fill distribution:
0 - 19% = 0
20 - 39% = 3
40 - 59% = 82
60 - 79% = 2
80 - 99% = 33
Index RDB$PRIMARY16 (0)
Depth: 2, leaf buckets: 241, nodes: 51918
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 4
40 - 59% = 156
60 - 79% = 4
80 - 99% = 77
Index SIGV_5_VIDEOCAM8_IDX1 (2)
Depth: 3, leaf buckets: 376, nodes: 51918
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 2
20 - 39% = 0
40 - 59% = 251
60 - 79% = 2
80 - 99% = 121
Index UNQ_SIGV_5_VIDEOCAM8 (1)
Depth: 3, leaf buckets: 300, nodes: 51918
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 6
20 - 39% = 24
40 - 59% = 121
60 - 79% = 118
80 - 99% = 31
SIGV_5_VIDEOCAM9 (170)
Primary pointer page: 271, Index root page: 272
Data pages: 745, data page slots: 745, average fill: 79%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 739
80 - 99% = 4
Index FK_SIGV_5_VIDEOCAM9 (3)
Depth: 2, leaf buckets: 47, nodes: 24535
Average data length: 0.00, total dup: 24532, max dup: 13887
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 18
60 - 79% = 2
80 - 99% = 26
Index RDB$PRIMARY17 (0)
Depth: 2, leaf buckets: 94, nodes: 24535
Average data length: 6.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 34
60 - 79% = 1
80 - 99% = 57
Index SIGV_5_VIDEOCAM9_IDX1 (2)
Depth: 2, leaf buckets: 135, nodes: 24535
Average data length: 13.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 30
60 - 79% = 0
80 - 99% = 103
Index UNQ_SIGV_5_VIDEOCAM9 (1)
Depth: 2, leaf buckets: 156, nodes: 24535
Average data length: 8.00, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 12
40 - 59% = 95
60 - 79% = 49
80 - 99% = 0
SIMPLE_EVENT (152)
Primary pointer page: 223, Index root page: 224
Data pages: 0, data page slots: 0, average fill: 0%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_SIMPLE_EVENT (1)
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
Index FK_SIMPLE_EVENT_SERVER_ID (2)
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
Index FK_SIMPLE_EVENT_TYPE (3)
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
Index PK_SIMPLE_EVENT (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
STATION (153)
Primary pointer page: 225, Index root page: 226
Data pages: 1, data page slots: 1, average fill: 17%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_STATION (0)
Depth: 1, leaf buckets: 1, nodes: 16
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 STATION_IDX1 (2)
Depth: 1, leaf buckets: 1, nodes: 16
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 UNQ_STATION (1)
Depth: 1, leaf buckets: 1, nodes: 16
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
STATION_CAMERAS (154)
Primary pointer page: 227, Index root page: 228
Data pages: 1, data page slots: 1, average fill: 11%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_STATION_CAMERA (1)
Depth: 1, leaf buckets: 1, nodes: 16
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 FK_STATION_STATION (2)
Depth: 1, leaf buckets: 1, nodes: 16
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 PK_STATION_CAMERAS (0)
Depth: 1, leaf buckets: 1, nodes: 16
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
If you need more information please tell me.
Thanks for the help.
Elisabete