|
Registriert seit: 31. Jan 2008
Ort: im schönen Salzburger Land
461 Beiträge
Delphi XE4 Professional
|
Performanceprobleme Firebird DB
13. Jan 2015, 15:37
Datenbank: Firebird • Version: 2.1 • Zugriff über: Zeos Lib
Hallo Leute,
Ich hab bei einer Datenbank extreme Performanceprobleme ... und ich finde die Ursache nicht 
Ich hab mit der IBOConsole eine Info-Abfrage der Datenbank gemacht .. möglicherweise findet jemand einen Hinweis WAS als Ursache infrage kommen könnte...
Vielen Dank für Hinweise
Erich
************************************************** ********
Code:
Service started at 13.01.2015 14:45:51
Database "C:\_database\DATABASE.FDB"
Database header page information:
Flags 0
Checksum 12345
Generation 131793
Page size 4096
ODS version 11.1
Oldest transaction 131780
Oldest active 131778
Oldest snapshot 131778
Next transaction 131783
Bumped transaction 1
Sequence number 0
Next attachment ID 8463
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 5, 2015 13:25:01
Attributes force write
Variable header data:
Sweep interval: 20000
*END*
Database file sequence:
File C:\_database\DATABASE.FDB is the only file
Analyzing database pages ...
ADRESS_BLOCK (250)
Primary pointer page: 489, Index root page: 490
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_ADRESS_BLOCK (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
ADRESS_BLOCKTITEL (249)
Primary pointer page: 487, Index root page: 488
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_ADRESS_BLOCKTITEL (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
ADRESS_KONTAKT (248)
Primary pointer page: 485, Index root page: 486
Data pages: 1, data page slots: 1, average fill: 10%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ADRESS_KONTAKT (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 2.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ADRESS_KONTAKT_MEMO (246)
Primary pointer page: 481, Index root page: 482
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_ADRESS_KONTAKT_MEMO (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
ADRESS_LINK (247)
Primary pointer page: 483, Index root page: 484
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_ADRESS_LINK (0)
Depth: 1, leaf buckets: 1, nodes: 5
Average data length: 2.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ADRESS_MEMO (245)
Primary pointer page: 479, Index root page: 480
Data pages: 1, data page slots: 1, average fill: 26%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ADRESS_MEMO (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 2.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
BDZ_AUTOMAT (216)
Primary pointer page: 420, Index root page: 421
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_BDZ_AUTOMAT (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
BDZ_DATEN (214)
Primary pointer page: 416, Index root page: 417
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_BDZ_DATEN (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
BDZ_PFAD (215)
Primary pointer page: 418, Index root page: 419
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_BDZ_PFAD (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
BDZ_TERMIN (218)
Primary pointer page: 424, Index root page: 425
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_BDZ_TERMIN (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
BDZ_ZAEHLER (213)
Primary pointer page: 414, Index root page: 415
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_BDZ_ZAEHLER (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
BDZ_ZEITRAUM (217)
Primary pointer page: 422, Index root page: 423
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_BDZ_ZEITRAUM (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
BENACHRICHTIGUNGEN (220)
Primary pointer page: 428, Index root page: 429
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_BENACHRICHTIGUNGEN (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
COMPANY (133)
Primary pointer page: 252, Index root page: 253
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_COMPANY (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
CONFIG_DB (179)
Primary pointer page: 345, Index root page: 346
Data pages: 62, data page slots: 63, average fill: 66%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 0
60 - 79% = 59
80 - 99% = 0
Index PK_CONFIG_DB (0)
Depth: 2, leaf buckets: 4, nodes: 3224
Average data length: 1.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 4
DATABASE_VERSION (130)
Primary pointer page: 245, Index root page: 246
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DATABASE_VERSION (0)
Depth: 1, leaf buckets: 1, nodes: 1
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
DATENPUNKTE_DB (185)
Primary pointer page: 357, Index root page: 358
Data pages: 17, data page slots: 17, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 16
80 - 99% = 0
Index PK_DATENPUNKTE_DB (0)
Depth: 1, leaf buckets: 1, nodes: 772
Average data length: 1.17, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
DB_ADRESSEN (146)
Primary pointer page: 278, Index root page: 279
Data pages: 2, data page slots: 2, average fill: 72%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index IDX_DB_ADRESSEN_1 (1)
Depth: 1, leaf buckets: 1, nodes: 47
Average data length: 1.38, 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_DB_ADRESSEN (0)
Depth: 1, leaf buckets: 1, nodes: 47
Average data length: 1.45, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_ARBEITSZEIT (163)
Primary pointer page: 312, Index root page: 313
Data pages: 1721, data page slots: 1721, average fill: 72%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1720
80 - 99% = 0
Index PK_DB_ARBEITSZEIT (0)
Depth: 2, leaf buckets: 99, nodes: 77228
Average data length: 1.06, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 98
DB_CHAT (187)
Primary pointer page: 361, Index root page: 362
Data pages: 1, data page slots: 1, average fill: 7%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DB_CHAT (0)
Depth: 1, leaf buckets: 1, nodes: 2
Average data length: 2.50, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_DOKUMENTE (152)
Primary pointer page: 290, Index root page: 291
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_DB_DOKUMENTE (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
DB_ERSATZTEILE (177)
Primary pointer page: 341, Index root page: 342
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 IDX_DB_ERSATZTEILE_1 (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 IDX_DB_ERSATZTEILE_2 (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_DB_ERSATZTEILE (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
DB_FAVORITEN (135)
Primary pointer page: 256, Index root page: 257
Data pages: 1, data page slots: 1, average fill: 34%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_DB_FAVORITEN (0)
Depth: 1, leaf buckets: 1, nodes: 30
Average data length: 1.93, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_HAUPTUNTERSUCHUNG (183)
Primary pointer page: 353, Index root page: 354
Data pages: 180, data page slots: 180, average fill: 88%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 179
Index IDX_DB_HAUPTUNTERSUCHUNG_1 (1)
Depth: 2, leaf buckets: 4, nodes: 3158
Average data length: 0.01, total dup: 3145, max dup: 370
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3
Index IDX_DB_HAUPTUNTERSUCHUNG_2 (2)
Depth: 2, leaf buckets: 4, nodes: 3158
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% = 4
Index PK_DB_HAUPTUNTERSUCHUNG (0)
Depth: 2, leaf buckets: 4, nodes: 3158
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% = 4
DB_MATERIAL (141)
Primary pointer page: 268, Index root page: 269
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_DB_MATERIAL (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
DB_MEMO (151)
Primary pointer page: 288, Index root page: 289
Data pages: 1, data page slots: 1, average fill: 61%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_DB_MEMO (0)
Depth: 1, leaf buckets: 1, nodes: 15
Average data length: 2.53, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_MENUDATA (176)
Primary pointer page: 339, Index root page: 340
Data pages: 1, data page slots: 1, average fill: 40%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_DB_MENUDATA (0)
Depth: 1, leaf buckets: 1, nodes: 36
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_MENU_POSSIBILITY (178)
Primary pointer page: 343, Index root page: 344
Data pages: 5, data page slots: 5, average fill: 55%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 0
Index PK_DB_MENU_POSSIBILITY (0)
Depth: 1, leaf buckets: 1, nodes: 228
Average data length: 1.09, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_PERSONEN (164)
Primary pointer page: 314, Index root page: 315
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_DB_PERSONEN (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
DB_SICHERHEIT (156)
Primary pointer page: 298, Index root page: 299
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_DB_SICHERHEIT (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
DB_STAMMDATEN (154)
Primary pointer page: 294, Index root page: 295
Data pages: 222, data page slots: 223, average fill: 80%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 90
80 - 99% = 131
Index IDX_DB_STAMMDATEN_1 (0)
Depth: 2, leaf buckets: 9, nodes: 7064
Average data length: 1.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
Index IDX_DB_STAMMDATEN_2 (1)
Depth: 2, leaf buckets: 8, nodes: 7064
Average data length: 0.13, total dup: 6498, max dup: 54
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 7
Index IDX_DB_STAMMDATEN_3 (2)
Depth: 2, leaf buckets: 9, nodes: 7064
Average data length: 1.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 9
DB_STOERFAELLE (147)
Primary pointer page: 280, Index root page: 281
Data pages: 38, data page slots: 38, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 37
Index IDX_DB_STOERFAELLE_1 (1)
Depth: 1, leaf buckets: 1, nodes: 733
Average data length: 0.21, total dup: 652, max dup: 10
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index IDX_DB_STOERFAELLE_2 (2)
Depth: 1, leaf buckets: 1, nodes: 733
Average data length: 1.10, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index PK_DB_STOERFAELLE (0)
Depth: 1, leaf buckets: 1, nodes: 733
Average data length: 1.11, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
DB_TAETIGKEIT (148)
Primary pointer page: 282, Index root page: 283
Data pages: 5543, data page slots: 5543, average fill: 81%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 2
60 - 79% = 2330
80 - 99% = 3210
Index IDX_DB_TAETIGKEIT_1 (1)
Depth: 2, leaf buckets: 220, nodes: 172783
Average data length: 0.43, total dup: 107776, max dup: 55
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 220
Index PK_DB_TAETIGKEIT (0)
Depth: 2, leaf buckets: 247, nodes: 172783
Average data length: 1.05, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 246
DB_TERMINECKDATEN (162)
Primary pointer page: 310, Index root page: 311
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 IDX_DB_TERMINECKDATEN_1 (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 IDX_DB_TERMINECKDATEN_2 (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 IDX_DB_TERMINECKDATEN_3 (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_DB_TERMINECKDATEN (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
DB_TERMINVORLAGEN (175)
Primary pointer page: 337, Index root page: 338
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_DB_DB_TERMINVORLAGEN (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
DB_UNFAELLE (168)
Primary pointer page: 322, Index root page: 323
Data pages: 92, data page slots: 92, average fill: 85%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 91
Index IDX_DB_UNFAELLE_1 (1)
Depth: 2, leaf buckets: 2, nodes: 1995
Average data length: 0.09, total dup: 1862, max dup: 14
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2
Index IDX_DB_UNFAELLE_2 (2)
Depth: 2, leaf buckets: 3, nodes: 1995
Average data length: 1.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
Index PK_DB_UNFAELLE (0)
Depth: 2, leaf buckets: 3, nodes: 1995
Average data length: 1.02, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 2
DB_USERBUTTONS (136)
Primary pointer page: 258, Index root page: 259
Data pages: 2, data page slots: 2, average fill: 71%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 1
Index PK_DB_USERBUTTONS (0)
Depth: 1, leaf buckets: 1, nodes: 25
Average data length: 1.84, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
DB_VORLAGEN (184)
Primary pointer page: 355, Index root page: 356
Data pages: 1, data page slots: 1, average fill: 54%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_DB_VORLAGEN (0)
Depth: 1, leaf buckets: 1, nodes: 10
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
DETAIL_DB (169)
Primary pointer page: 324, Index root page: 325
Data pages: 94, data page slots: 94, average fill: 89%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 92
Index IDX_DETAIL_DB_1 (1)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 0.90, total dup: 303, max dup: 89
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_DB_2 (2)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 1.10, total dup: 610, max dup: 470
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_DB_3 (3)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 1.52, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_1 (4)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 0.90, total dup: 303, max dup: 89
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_2 (5)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 1.10, total dup: 610, max dup: 470
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_3 (6)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 1.52, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_4 (7)
Depth: 2, leaf buckets: 27, nodes: 813
Average data length: 115.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 2
60 - 79% = 1
80 - 99% = 24
Index IDX_DETAIL_SEC_5 (8)
Depth: 1, leaf buckets: 1, nodes: 813
Average data length: 0.01, total dup: 811, max dup: 810
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index IDX_DETAIL_SEC_6 (9)
Depth: 1, leaf buckets: 1, nodes: 813
Average data length: 0.00, total dup: 812, max dup: 812
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index IDX_DETAIL_SEC_7 (10)
Depth: 1, leaf buckets: 1, nodes: 813
Average data length: 0.22, total dup: 807, max dup: 580
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_8 (11)
Depth: 1, leaf buckets: 1, nodes: 813
Average data length: 0.16, total dup: 691, max dup: 230
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index IDX_DETAIL_SEC_9 (12)
Depth: 2, leaf buckets: 6, nodes: 813
Average data length: 20.45, total dup: 392, max dup: 31
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 5
Index PK_DETAIL_DB (0)
Depth: 2, leaf buckets: 2, nodes: 813
Average data length: 1.49, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
DUMMYPRINT_DB (182)
Primary pointer page: 351, Index root page: 352
Data pages: 2, data page slots: 2, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1
Index PK_DUMMYPRINT_DB (0)
Depth: 1, leaf buckets: 1, nodes: 22
Average data length: 1.86, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ELEKTROLEITUNGEN (157)
Primary pointer page: 300, Index root page: 301
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_ELEKTROLEITUNGEN (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
ELEKTROPUNKTE (155)
Primary pointer page: 296, Index root page: 297
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_ELEKTROPUNKTE (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
ERSATZTEILE_DB (171)
Primary pointer page: 329, Index root page: 330
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_ERSATZTEILE_DB (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
ERSATZTEIL_HERSTELLER (254)
Primary pointer page: 497, Index root page: 498
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_ERSATZTEIL_HERSTELLER (0)
Depth: 1, leaf buckets: 1, nodes: 1
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
ERSATZTEIL_LIEFERANT (244)
Primary pointer page: 476, Index root page: 477
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_ERSATZTEIL_LIEFERANT (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
ERSATZTEIL_LINK (253)
Primary pointer page: 495, Index root page: 496
Data pages: 3, data page slots: 3, average fill: 57%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 2
80 - 99% = 0
Index PK_ERSATZTEIL_LINK (0)
Depth: 1, leaf buckets: 1, nodes: 77
Average data length: 1.30, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ERSATZTEIL_MAIN (251)
Primary pointer page: 491, Index root page: 492
Data pages: 2, data page slots: 2, average fill: 46%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 1
Index PK_ERSATZTEIL_MAIN (0)
Depth: 1, leaf buckets: 1, nodes: 24
Average data length: 1.63, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ERSATZTEIL_MAIN_MEMO (252)
Primary pointer page: 493, Index root page: 494
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_ERSATZTEIL_MAIN_MEMO (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
ERSATZTEIL_MEMO (242)
Primary pointer page: 472, Index root page: 473
Data pages: 1, data page slots: 1, average fill: 41%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_ERSATZTEIL_MEMO (0)
Depth: 1, leaf buckets: 1, nodes: 21
Average data length: 1.62, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
ERSATZTEIL_PREIS (243)
Primary pointer page: 474, Index root page: 475
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 PK_ERSATZTEIL_PREIS (0)
Depth: 1, leaf buckets: 1, nodes: 13
Average data length: 1.23, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
FILE_TEMPLATES (143)
Primary pointer page: 272, Index root page: 273
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_FILE_TEMPLATES (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
FREIGABE_STRUCTURE (205)
Primary pointer page: 397, Index root page: 398
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 RDB$PRIMARY1 (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
FREIGABE_USER (203)
Primary pointer page: 393, Index root page: 394
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
GPS_POSITIONEN (224)
Primary pointer page: 436, Index root page: 437
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
HISTORY_DB (186)
Primary pointer page: 359, Index root page: 360
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_DHISTORY_DB (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
KATEGORIEN (212)
Primary pointer page: 412, Index root page: 413
Data pages: 2, data page slots: 2, average fill: 47%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_KATEGORIEN (0)
Depth: 1, leaf buckets: 1, nodes: 56
Average data length: 1.52, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
KEY_DB (139)
Primary pointer page: 264, Index root page: 265
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_KEY_DB (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
LANGUAGE (134)
Primary pointer page: 254, Index root page: 255
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_LANGUAGE (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
LAST_MATERIAL (222)
Primary pointer page: 432, Index root page: 433
Data pages: 1, data page slots: 1, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_LAST_MATERIAL (0)
Depth: 1, leaf buckets: 1, nodes: 54
Average data length: 1.07, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LAST_PERSONS (221)
Primary pointer page: 430, Index root page: 431
Data pages: 5, data page slots: 5, average fill: 53%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 0
Index PK_LAST_PERSONS (0)
Depth: 1, leaf buckets: 1, nodes: 244
Average data length: 1.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
LUFTLEITUNGEN (161)
Primary pointer page: 308, Index root page: 309
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_LUFTLEITUNGEN (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
LUFTPUNKTE (160)
Primary pointer page: 306, Index root page: 307
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_LUFTPUNKTE (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
MAIN_VORLAGEN_DB (144)
Primary pointer page: 274, Index root page: 275
Data pages: 4, data page slots: 4, average fill: 86%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 3
Index PK_MAIN_VORLAGEN_DB (0)
Depth: 1, leaf buckets: 1, nodes: 42
Average data length: 1.71, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
MATERIAL_DB (172)
Primary pointer page: 331, Index root page: 332
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_MATERIAL_DB (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
NAVIGATOR_DB (173)
Primary pointer page: 333, Index root page: 334
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_NAVIGATOR_DB (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
NAVIGATOR_GRUPPEN (210)
Primary pointer page: 408, Index root page: 409
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
NAVIGATOR_ITEMS (174)
Primary pointer page: 335, Index root page: 336
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_NAVIGATOR_ITEMS (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
NAVIGATOR_POSITION (170)
Primary pointer page: 327, Index root page: 328
Data pages: 1, data page slots: 1, average fill: 8%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_NAVIGATOR_POSITION (0)
Depth: 1, leaf buckets: 1, nodes: 7
Average data length: 2.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
OVERVIEW_DB (137)
Primary pointer page: 260, Index root page: 261
Data pages: 413, data page slots: 413, average fill: 78%
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 370
80 - 99% = 40
Index IDX_OVERVIEW_DB_1 (1)
Depth: 2, leaf buckets: 15, nodes: 14530
Average data length: 0.09, total dup: 13737, max dup: 372
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 15
Index IDX_OVERVIEW_DB_2 (2)
Depth: 2, leaf buckets: 15, nodes: 14530
Average data length: 0.01, total dup: 14481, max dup: 5497
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 14
Index PK_OVERVIEW_DB (0)
Depth: 2, leaf buckets: 19, nodes: 14530
Average data length: 1.03, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 18
PACKER_DB (165)
Primary pointer page: 316, Index root page: 317
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_PACKER_DB (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
PACKER_ITEMS (166)
Primary pointer page: 318, Index root page: 319
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_PACKER_ITEMS (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
PACKER_POSITION (167)
Primary pointer page: 320, Index root page: 321
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_PACKER_POSITION (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
PERSONEN_FIRMEN_DB (140)
Primary pointer page: 266, Index root page: 267
Data pages: 3, data page slots: 3, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 2
Index PK_PERSONEN_FIRMEN_DB (0)
Depth: 1, leaf buckets: 1, nodes: 40
Average data length: 1.73, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
QR_VORLAGEN (188)
Primary pointer page: 363, Index root page: 364
Data pages: 1, data page slots: 1, average fill: 24%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_QR_VORLAGEN (0)
Depth: 1, leaf buckets: 1, nodes: 14
Average data length: 2.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
QR_VORLAGEN_TEXT (189)
Primary pointer page: 365, Index root page: 366
Data pages: 1, data page slots: 1, average fill: 8%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index FK_QR_VORLAGEN_TEXT (0)
Depth: 1, leaf buckets: 1, nodes: 6
Average data length: 2.33, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
REPORT_TEMPLATES (142)
Primary pointer page: 270, Index root page: 271
Data pages: 4, data page slots: 4, average fill: 70%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 3
Index PK_REPORT_TEMPLATES (0)
Depth: 1, leaf buckets: 1, nodes: 52
Average data length: 1.04, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
SCHNEILEITUNGEN (159)
Primary pointer page: 304, Index root page: 305
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_SCHNEILEITUNGEN (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
SCHNEIPUNKTE (158)
Primary pointer page: 302, Index root page: 303
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_SCHNEIPUNKTE (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
STRUCTURE (128)
Primary pointer page: 241, Index root page: 242
Data pages: 1258, data page slots: 1258, average fill: 90%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 4
60 - 79% = 7
80 - 99% = 1247
Index IDX_STRUCTURE_1 (1)
Depth: 2, leaf buckets: 14, nodes: 12759
Average data length: 0.26, total dup: 10455, max dup: 167
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 13
Index IDX_STRUCTURE_2 (2)
Depth: 2, leaf buckets: 14, nodes: 12759
Average data length: 0.21, total dup: 12128, max dup: 2347
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 13
Index IDX_STRUCTURE_3 (3)
Depth: 2, leaf buckets: 18, nodes: 12759
Average data length: 1.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 17
Index PK_STRUCTURE (0)
Depth: 2, leaf buckets: 18, nodes: 12759
Average data length: 1.24, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 17
SUBKEY_DB (150)
Primary pointer page: 286, Index root page: 287
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_SUBKEY_DB (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
TABLE_OPTIC (132)
Primary pointer page: 249, Index root page: 250
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_TABLE_OPTIC (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
TAG_ADDRESS (138)
Primary pointer page: 262, Index root page: 263
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_TAG_ADDRESS (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
TERMIN_ARBEITER (234)
Primary pointer page: 456, Index root page: 457
Data pages: 1051, data page slots: 1051, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1051
60 - 79% = 0
80 - 99% = 0
Index PK_TERMIN_ARBEITER (0)
Depth: 2, leaf buckets: 100, nodes: 78083
Average data length: 1.06, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 99
TERMIN_ARBEITER_MANUELL (235)
Primary pointer page: 458, Index root page: 459
Data pages: 1231, data page slots: 1231, average fill: 67%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 6
60 - 79% = 1224
80 - 99% = 0
Index PK_TERMIN_ARBEITER_MANUELL (0)
Depth: 2, leaf buckets: 88, nodes: 68825
Average data length: 1.06, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 87
TERMIN_ERINNERUNG (232)
Primary pointer page: 452, Index root page: 453
Data pages: 128, data page slots: 128, average fill: 53%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 127
60 - 79% = 0
80 - 99% = 0
Index PK_TERMIN_ERINNERUNG (0)
Depth: 2, leaf buckets: 13, nodes: 9498
Average data length: 1.21, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 12
TERMIN_INTERVALL (231)
Primary pointer page: 450, Index root page: 451
Data pages: 925, data page slots: 925, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 924
60 - 79% = 0
80 - 99% = 0
Index PK_TERMIN_INTERVALL (0)
Depth: 2, leaf buckets: 85, nodes: 64629
Average data length: 1.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 85
TERMIN_ISTZEIT (236)
Primary pointer page: 460, Index root page: 461
Data pages: 3, data page slots: 3, average fill: 56%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 3
60 - 79% = 0
80 - 99% = 0
Index PK_TERMIN_ISTZEIT (0)
Depth: 1, leaf buckets: 1, nodes: 222
Average data length: 1.57, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TERMIN_MAIN (230)
Primary pointer page: 448, Index root page: 449
Data pages: 5824, data page slots: 5825, average fill: 90%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 2
60 - 79% = 12
80 - 99% = 5808
Index PK_TERMIN_MAIN (0)
Depth: 2, leaf buckets: 96, nodes: 64975
Average data length: 1.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 95
TERMIN_MATERIAL (237)
Primary pointer page: 462, Index root page: 463
Data pages: 2, data page slots: 2, average fill: 35%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_TERMIN_MATERIAL (0)
Depth: 1, leaf buckets: 1, nodes: 79
Average data length: 1.23, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TERMIN_MATERIAL_MANUELL (238)
Primary pointer page: 464, Index root page: 465
Data pages: 1, data page slots: 1, average fill: 60%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 0
Index PK_TERMIN_MATERIAL_MANUELL (0)
Depth: 1, leaf buckets: 1, nodes: 48
Average data length: 1.31, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
TERMIN_MEMO_ARBEITSSCHUTZ (239)
Primary pointer page: 466, Index root page: 467
Data pages: 1422, data page slots: 1422, average fill: 82%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 1419
Index PK_TERMIN_MEMO_ARBEITSSCHUTZ (0)
Depth: 2, leaf buckets: 57, nodes: 42608
Average data length: 1.16, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 56
TERMIN_MEMO_BEMERKUNG (240)
Primary pointer page: 468, Index root page: 469
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_TERMIN_MEMO_BEMERKUNG (0)
Depth: 2, 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
TERMIN_MEMO_DOKU (241)
Primary pointer page: 470, Index root page: 471
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_TERMIN_MEMO_DOKU (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
TERMIN_SOLLZEIT (233)
Primary pointer page: 454, Index root page: 455
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_TERMIN_SOLLZEIT (0)
Depth: 2, 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
TRANSLATE_INR (149)
Primary pointer page: 284, Index root page: 285
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_TRANSLATE_INR (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
T_CHECKLISTE (194)
Primary pointer page: 375, Index root page: 376
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 IDX_T_CHECKLISTE_1 (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_T_CHECKLISTE (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
T_CLIENTS (191)
Primary pointer page: 369, Index root page: 370
Data pages: 1, data page slots: 1, average fill: 51%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_T_CLIENTS (0)
Depth: 1, leaf buckets: 1, nodes: 37
Average data length: 2.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_DOKUMENTE (207)
Primary pointer page: 401, Index root page: 402
Data pages: 2128, data page slots: 2128, average fill: 87%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2
80 - 99% = 2125
T_DOKUMENTE_LINK (206)
Primary pointer page: 399, Index root page: 400
Data pages: 2677, data page slots: 2677, average fill: 88%
Fill distribution:
0 - 19% = 1
20 - 39% = 1
40 - 59% = 0
60 - 79% = 3
80 - 99% = 2672
T_DOKUMENTE_MENU (208)
Primary pointer page: 404, Index root page: 405
Data pages: 653, data page slots: 653, average fill: 57%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 653
60 - 79% = 0
80 - 99% = 0
T_DRUCKBILD (227)
Primary pointer page: 442, Index root page: 443
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_T_DRUCKBILD (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
T_ERLEDIGT (225)
Primary pointer page: 438, Index root page: 439
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
T_FUNKTIONEN (229)
Primary pointer page: 446, Index root page: 447
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_T_FUNKTIONEN (0)
Depth: 1, leaf buckets: 1, nodes: 22
Average data length: 5.18, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_KEYS (181)
Primary pointer page: 349, Index root page: 350
Data pages: 1354, data page slots: 1752, average fill: 55%
Fill distribution:
0 - 19% = 2
20 - 39% = 3
40 - 59% = 1349
60 - 79% = 0
80 - 99% = 0
Index IDX_SEC_KEYS_1 (1)
Depth: 2, leaf buckets: 321, nodes: 102660
Average data length: 0.16, total dup: 89901, max dup: 8
Fill distribution:
0 - 19% = 0
20 - 39% = 214
40 - 59% = 106
60 - 79% = 1
80 - 99% = 0
Index IDX_SEC_KEYS_2 (2)
Depth: 2, leaf buckets: 240, nodes: 102660
Average data length: 0.04, total dup: 100356, max dup: 12758
Fill distribution:
0 - 19% = 1
20 - 39% = 83
40 - 59% = 136
60 - 79% = 18
80 - 99% = 2
Index RDB$PRIMARY2 (0)
Depth: 3, leaf buckets: 362, nodes: 102660
Average data length: 1.40, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 7
20 - 39% = 127
40 - 59% = 223
60 - 79% = 5
80 - 99% = 0
T_KOSTENSCHAETZUNG (190)
Primary pointer page: 367, Index root page: 368
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_T_KOSTENSCHAETZUNG (0)
Depth: 1, leaf buckets: 1, nodes: 31
Average data length: 2.84, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_NOTIZEN (198)
Primary pointer page: 383, Index root page: 384
Data pages: 169, data page slots: 169, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 122
80 - 99% = 46
Index IDX_T_NOTIZEN (1)
Depth: 2, leaf buckets: 8, nodes: 6100
Average data length: 1.15, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 8
Index PK_T_NOTIZEN (0)
Depth: 2, leaf buckets: 8, nodes: 6100
Average data length: 1.15, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 8
T_QUALIFIKATION (197)
Primary pointer page: 381, Index root page: 382
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_T_QUALIFIKATION (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
T_QUAL_BEM (192)
Primary pointer page: 371, Index root page: 372
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_T_QUAL_BEM (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
T_REVPRINT (226)
Primary pointer page: 440, Index root page: 441
Data pages: 1, data page slots: 1, average fill: 38%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_T_REVPRINT (0)
Depth: 1, leaf buckets: 1, nodes: 28
Average data length: 1.14, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_REV_TEXTFILTER (223)
Primary pointer page: 434, Index root page: 435
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_T_REV_TEXTFILTER (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
T_SCHNELLSTART (193)
Primary pointer page: 373, Index root page: 374
Data pages: 1, data page slots: 1, average fill: 58%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_T_SCHNELLSTART (0)
Depth: 1, leaf buckets: 1, nodes: 37
Average data length: 1.86, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_SIGNATURE (228)
Primary pointer page: 444, Index root page: 445
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 RDB$PRIMARY3 (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
T_SS_FILTER (196)
Primary pointer page: 379, Index root page: 380
Data pages: 5, data page slots: 5, average fill: 78%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 4
Index PK_T_SS_FILTER (0)
Depth: 1, leaf buckets: 1, nodes: 74
Average data length: 1.43, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
T_SS_WINDOW (195)
Primary pointer page: 377, Index root page: 378
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_T_SS_WINDOW (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
UPDATE_DB (180)
Primary pointer page: 347, Index root page: 348
Data pages: 1, data page slots: 1, average fill: 1%
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_UPDATE_DB (0)
Depth: 1, leaf buckets: 1, nodes: 1
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
USERCONFIG (153)
Primary pointer page: 292, Index root page: 293
Data pages: 1, data page slots: 1, average fill: 21%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_USERCONFIG (0)
Depth: 1, leaf buckets: 1, nodes: 23
Average data length: 1.78, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
USERGROUP (129)
Primary pointer page: 243, Index root page: 244
Data pages: 1, data page slots: 1, average fill: 27%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_USERGROUP (0)
Depth: 1, leaf buckets: 1, nodes: 26
Average data length: 1.08, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
USERNAME (131)
Primary pointer page: 247, Index root page: 248
Data pages: 1, data page slots: 1, average fill: 48%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_USERNAME (0)
Depth: 1, leaf buckets: 1, nodes: 23
Average data length: 1.91, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
USER_LOGIN (219)
Primary pointer page: 426, Index root page: 427
Data pages: 1, data page slots: 1, average fill: 38%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_USER_LOGIN (0)
Depth: 1, leaf buckets: 1, nodes: 22
Average data length: 2.27, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
VORLAGEN_DB (145)
Primary pointer page: 276, Index root page: 277
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_VORLAGEN_DB (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
VORLAGE_IM_TERMIN (255)
Primary pointer page: 499, Index root page: 500
Data pages: 1, data page slots: 1, average fill: 39%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
Index PK_VORLAGE_IM_TERMIN (0)
Depth: 1, leaf buckets: 1, nodes: 38
Average data length: 1.32, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WE_DATUM (201)
Primary pointer page: 389, Index root page: 390
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_WE_DATUM (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
WE_DATUM_STAMM (211)
Primary pointer page: 410, Index root page: 411
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_WE_DATUM_STAMM (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
WE_DOUBLE (204)
Primary pointer page: 395, Index root page: 396
Data pages: 2, data page slots: 2, average fill: 44%
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index FK_WE_DOUBLE (0)
Depth: 1, leaf buckets: 1, nodes: 128
Average data length: 1.83, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WE_DOUBLE_STAMM (209)
Primary pointer page: 406, Index root page: 407
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_WE_DOUBLE_STAMM (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
WE_STAMMDATEN (202)
Primary pointer page: 391, Index root page: 392
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_WE_STAMMDATEN_1 (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_WE_STAMMDATEN_2 (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_WE_STAMMDATEN (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
WE_VORLAGEN (199)
Primary pointer page: 385, Index root page: 386
Data pages: 1, data page slots: 1, average fill: 53%
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0
Index PK_WE_VORLAGEN (0)
Depth: 1, leaf buckets: 1, nodes: 26
Average data length: 1.81, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0
WE_WERTE (200)
Primary pointer page: 387, Index root page: 388
Data pages: 2794, data page slots: 2794, average fill: 64%
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 3
60 - 79% = 2788
80 - 99% = 0
Index FK_WE_WERTE_1 (1)
Depth: 2, leaf buckets: 183, nodes: 172783
Average data length: 0.00, total dup: 172771, max dup: 172300
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 2
60 - 79% = 0
80 - 99% = 180
Index PK_WE_WERTE (0)
Depth: 2, leaf buckets: 229, nodes: 172783
Average data length: 1.05, total dup: 0, max dup: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 229
Service ended at 13.01.2015 14:46:04
Erich Wanker - for life:=1971 to lebensende do begin ..
O
/H\
/ \
|