Performanceprobleme Firebird DB

[erich.wanker]

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

[mkinzler]

Wie äussern sich diese? Interessant wären auch die problematischen Abfrage und deren Plan.

[EgonHugeist]

Und welche ZeosLib-Version?
Alle unter 7.2 sind "etwas" lahm..

[tsteinmaurer]

Wie Markus schon gesagt hat, wäre es interessant zu erfahren, wie sich die Performanceprobleme äußern. Der gstat Output ist zwar interessant und mit Page Buffers = 0 ist der Firebird PageCache sehr niedrig, sofern man den Default in firebird.conf nicht geändert hat, aber zu 80% ist es immer eine Kombination aus Client-Anwendung mit langsamen SQLs und Problemen im (physischen) Datenmodell. Zuvor sollte man allerdings eine solide Basis der Grund/Tuning-Einstellungen des FB Servers sicherstellen.

LG