![]() |
Datenbank: Firebird • Version: 2.1 • Zugriff über: Zeos Lib
Performanceprobleme Firebird DB
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 |
AW: Performanceprobleme Firebird DB
Wie äussern sich diese? Interessant wären auch die problematischen Abfrage und deren Plan.
|
AW: Performanceprobleme Firebird DB
Und welche ZeosLib-Version?
Alle unter 7.2 sind "etwas" lahm.. |
AW: Performanceprobleme Firebird DB
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 |
Alle Zeitangaben in WEZ +1. Es ist jetzt 11:11 Uhr. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO © 2011, Crawlability, Inc.
Delphi-PRAXiS (c) 2002 - 2023 by Daniel R. Wolf, 2024 by Thomas Breitkreuz