Tests

TAB_NAME IDX_NAME IDX_KEY
XQD_1000_1200 XQD_1000_1200_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1000_3300 XQD_1000_3300_DOC DOC_ID
XQD_1000_3300 XQD_1000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_1200_2000 XQD_1200_2000_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2000_3300 XQD_2000_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_2100_3300 XQD_2100_3300_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID
XQD_3300_3400 XQD_3300_3400_WARE_SOP_ROP_SND WARE_ID,SND_OPTYPE_ID,RCV_OPTYPE_ID,SND_ID

Performance reports

Performance in TOTAL:

ACTION AVG_TIMES_PER_MINUTE AVG_ELAPSED_MS SUCCESSFUL_TIMES_DONE JOB_BEG JOB_END
*** OVERALL *** for 180 minutes: 6015.27 4194 1082748 2017-03-29 08:24 2017-03-29 11:24
customer order: creation 450.41 565 81074 2017-03-29 08:24 2017-03-29 11:24
customer order: refuse 37.11 296 6680 2017-03-29 08:24 2017-03-29 11:24
order to supplier: creation 116.74 2455 21013 2017-03-29 08:24 2017-03-29 11:24
order to supplier: removal 2.92 27981 522 2017-03-29 08:24 2017-03-29 11:24
invoice (draft): creation 116.25 3489 20925 2017-03-29 08:24 2017-03-29 11:24
invoice (draft): removal 39.83 585 7170 2017-03-29 08:24 2017-03-29 11:24
invoice accept: apply 68.30 15662 12294 2017-03-29 08:24 2017-03-29 11:24
invoice accept: cancel 18.89 3420 3382 2017-03-29 08:24 2017-03-29 11:24
customer reserve: creation 3513.31 258 632395 2017-03-29 08:24 2017-03-29 11:24
customer reserve: removal 1035.07 90 185277 2017-03-29 08:24 2017-03-29 11:24
realization accept: apply 210.04 588 37808 2017-03-29 08:24 2017-03-29 11:24
realization accept: cancel 82.45 205 14758 2017-03-29 08:24 2017-03-29 11:24
payment from customer: creation 152.22 1064 27399 2017-03-29 08:24 2017-03-29 11:24
payment from customer: removal 14.74 149 2638 2017-03-29 08:24 2017-03-29 11:24
payment to supplier: creation 125.53 764 22596 2017-03-29 08:24 2017-03-29 11:24
payment to supplier: removal 8.99 149 1610 2017-03-29 08:24 2017-03-29 11:24
service: total inventory turnovers 7.77 4685 1398 2017-03-29 08:24 2017-03-29 11:24
service: total monetary turnovers 21.21 63 3797 2017-03-29 08:24 2017-03-29 11:24
service: refresh index statistics 0.07 17217 12 2017-03-29 08:24 2017-03-29 11:24
Done for 136520 ms, from 11:29:59.81 to 11:32:16.33.

Performance in DYNAMIC:

ACTION ITRV_NO CNT_OK_PER_MINUTE CNT_ALL CNT_OK CNT_ERR ERR_PRC ITRV_BEG ITRV_END
interval # 1, overall 1 4034 85142 72610 12532 14.72 08:24:01 08:42:01
interval # 2, overall 2 5139 102402 92498 9904 9.67 08:42:02 09:00:02
interval # 3, overall 3 5539 110447 99701 10746 9.73 09:00:03 09:18:03
interval # 4, overall 4 7149 138908 128688 10220 7.36 09:18:04 09:36:04
interval # 5, overall 5 6081 122707 109452 13255 10.80 09:36:05 09:54:05
interval # 6, overall 6 6298 129717 113355 16362 12.61 09:54:06 10:12:06
interval # 7, overall 7 6569 133596 118239 15357 11.50 10:12:07 10:30:07
interval # 8, overall 8 6820 137432 122757 14675 10.68 10:30:08 10:48:08
interval # 9, overall 9 6550 131224 117907 13317 10.15 10:48:09 11:06:09
interval # 10, overall 10 5975 116801 107541 9260 7.93 11:06:10 11:24:10
Done for 234690 ms, from 11:36:10.34 to 11:40:05.03.

Performance for every MINUTE:

TEST_PHASE MINUTE_SINCE_TEST_START AVG_ESTIMATED MIN_TO_AVG_RATIO MAX_TO_AVG_RATIO ROWS_AGGREGATED DISTINCT_ATTACHMENTS
TEST_TIME 1 5872.99 0.5555 1.3434 2030 65
TEST_TIME 2 4819.92 0.8185 1.1195 780 75
TEST_TIME 3 4320.30 0.8333 1.1562 1352 100
TEST_TIME 4 4347.95 0.8616 1.1217 1725 100
TEST_TIME 5 4308.61 0.9056 1.0675 2078 100
TEST_TIME 6 4139.35 0.9260 1.0912 1529 98
TEST_TIME 7 4192.64 0.9256 1.0684 2264 100
TEST_TIME 8 4151.51 0.9441 1.0490 1815 98
TEST_TIME 9 4242.40 0.9125 1.0375 1661 98
TEST_TIME 10 4185.10 0.9466 1.0630 1973 98
TEST_TIME 11 4220.90 0.9582 1.0686 1469 99
TEST_TIME 12 4229.49 0.9776 1.0240 1646 91
TEST_TIME 13 4163.99 0.9602 1.0354 1444 94
TEST_TIME 14 4153.52 0.9639 1.0295 1734 98
TEST_TIME 15 4079.20 0.9784 1.0265 1661 88
TEST_TIME 16 4043.34 0.9709 1.0316 1590 91
TEST_TIME 17 4089.06 0.9600 1.0320 1797 100
TEST_TIME 18 4106.14 0.9706 1.0414 1917 91
TEST_TIME 19 4224.26 0.9590 1.0313 1845 94
TEST_TIME 20 4271.86 0.9688 1.0243 2051 90
TEST_TIME 21 4293.00 0.9707 1.0370 1543 92
TEST_TIME 22 4330.26 0.9813 1.0291 1710 94
TEST_TIME 23 4368.89 0.9757 1.0262 1825 92
TEST_TIME 24 4388.93 0.9790 1.0333 1804 90
TEST_TIME 25 4427.18 0.9834 1.0119 1815 91
TEST_TIME 26 4432.34 0.9718 1.0133 1521 97
TEST_TIME 27 4414.38 0.9797 1.0211 1743 93
TEST_TIME 28 4438.05 0.9805 1.0069 1328 97
TEST_TIME 29 4355.04 0.9907 1.0122 1312 85
TEST_TIME 30 4360.13 0.9773 1.0194 1403 93
TEST_TIME 31 4373.05 0.9836 1.0205 1346 96
TEST_TIME 32 4399.55 0.9827 1.0164 2127 94
TEST_TIME 33 4465.60 0.9710 1.0308 2078 92
TEST_TIME 34 4539.24 0.9842 1.0192 1939 90
TEST_TIME 35 4579.34 0.9814 1.0269 2034 84
TEST_TIME 36 4659.28 0.9823 1.0202 2066 89
TEST_TIME 37 4702.93 0.9834 1.0153 1631 98
TEST_TIME 38 4677.64 0.9939 1.0089 1657 85
TEST_TIME 39 4684.15 0.9816 1.0185 1542 89
TEST_TIME 40 4713.28 0.9869 1.0127 1783 90
TEST_TIME 41 4737.54 0.9829 1.0103 1690 88
TEST_TIME 42 4718.07 0.9903 1.0117 1497 81
TEST_TIME 43 4731.85 0.9853 1.0162 1588 85
TEST_TIME 44 4740.90 0.9913 1.0103 1403 78
TEST_TIME 45 4781.98 0.9842 1.0108 1308 81
TEST_TIME 46 4775.82 0.9902 1.0075 1448 82
TEST_TIME 47 4778.16 0.9856 1.0210 1697 92
TEST_TIME 48 4854.52 0.9842 1.0097 1660 91
TEST_TIME 49 4888.83 0.9824 1.0146 2080 87
TEST_TIME 50 4919.31 0.9882 1.0140 2107 80
TEST_TIME 51 4959.03 0.9862 1.0188 1744 80
TEST_TIME 52 4984.77 0.9952 1.0107 779 87
TEST_TIME 53 4966.86 0.9953 1.0036 633 80
TEST_TIME 54 4949.65 0.9885 1.0133 2092 74
TEST_TIME 55 4994.74 0.9859 1.0128 1681 84
TEST_TIME 56 5026.79 0.9884 1.0138 1643 77
TEST_TIME 57 5050.66 0.9914 1.0097 1589 75
TEST_TIME 58 5054.43 0.9915 1.0060 1043 71
TEST_TIME 59 5049.49 0.9899 1.0135 1423 87
TEST_TIME 60 5081.01 0.9905 1.0067 1328 83
TEST_TIME 61 5085.12 0.9894 1.0116 1348 86
TEST_TIME 62 5157.40 0.9814 1.0152 1890 78
TEST_TIME 63 5221.61 0.9868 1.0110 2121 72
TEST_TIME 64 5269.55 0.9861 1.0162 1916 78
TEST_TIME 65 5317.89 0.9914 1.0091 951 74
TEST_TIME 66 5335.90 0.9905 1.0105 1943 69
TEST_TIME 67 5375.59 0.9903 1.0105 1580 65
TEST_TIME 68 5398.48 0.9914 1.0137 1329 54
TEST_TIME 69 5424.78 0.9946 1.0077 1195 68
TEST_TIME 70 5447.64 0.9891 1.0092 1411 66
TEST_TIME 71 5473.86 0.9902 1.0095 1438 69
TEST_TIME 72 5492.69 0.9921 1.0047 1380 68
TEST_TIME 73 5481.08 0.9930 1.0055 631 63
TEST_TIME 74 5457.31 0.9963 1.0053 1462 59
TEST_TIME 75 5461.25 0.9912 1.0071 1157 73
TEST_TIME 76 5470.17 0.9940 1.0036 1279 81
TEST_TIME 77 5456.19 0.9931 1.0090 1149 87
TEST_TIME 78 5479.96 0.9917 1.0054 1494 83
TEST_TIME 79 5511.16 0.9870 1.0084 1885 80
TEST_TIME 80 5539.89 0.9906 1.0069 1660 77
TEST_TIME 81 5546.16 0.9934 1.0073 1391 75
TEST_TIME 82 5569.15 0.9911 1.0094 1300 74
TEST_TIME 83 5589.56 0.9936 1.0060 1454 86
TEST_TIME 84 5592.45 0.9935 1.0051 1395 84
TEST_TIME 85 5586.20 0.9944 1.0067 1315 79
TEST_TIME 86 5597.28 0.9930 1.0067 1369 73
TEST_TIME 87 5603.87 0.9940 1.0070 1006 86
TEST_TIME 88 5605.74 0.9953 1.0072 1161 84
TEST_TIME 89 5601.79 0.9966 1.0050 1450 82
TEST_TIME 90 5605.98 0.9931 1.0039 1215 93
TEST_TIME 91 5585.85 0.9965 1.0036 1338 86
TEST_TIME 92 5577.91 0.9941 1.0044 1411 86
TEST_TIME 93 5593.49 0.9908 1.0061 1201 85
TEST_TIME 94 5588.55 0.9963 1.0089 1418 81
TEST_TIME 95 5633.06 0.9904 1.0067 1415 77
TEST_TIME 96 5646.29 0.9939 1.0070 1729 72
TEST_TIME 97 5675.51 0.9917 1.0080 1366 75
TEST_TIME 98 5710.38 0.9916 1.0069 1441 74
TEST_TIME 99 5735.36 0.9924 1.0072 1530 69
TEST_TIME 100 5748.34 0.9950 1.0025 1295 66
TEST_TIME 101 5735.18 0.9948 1.0041 1226 74
TEST_TIME 102 5723.44 0.9963 1.0039 1109 65
TEST_TIME 103 5730.67 0.9929 1.0025 1118 69
TEST_TIME 104 5717.11 0.9952 1.0045 1054 81
TEST_TIME 105 5706.17 0.9969 1.0050 1269 79
TEST_TIME 106 5706.55 0.9955 1.0043 1258 74
TEST_TIME 107 5705.77 0.9950 1.0054 1334 84
TEST_TIME 108 5724.50 0.9932 1.0053 1740 82
TEST_TIME 109 5755.34 0.9907 1.0053 1796 77
TEST_TIME 110 5766.85 0.9942 1.0056 1661 75
TEST_TIME 111 5783.99 0.9936 1.0055 1654 78
TEST_TIME 112 5790.93 0.9954 1.0042 1698 74
TEST_TIME 113 5796.75 0.9943 1.0055 1476 71
TEST_TIME 114 5804.77 0.9953 1.0061 1439 64
TEST_TIME 115 5805.92 0.9976 1.0031 1396 76
TEST_TIME 116 5799.87 0.9955 1.0046 1290 70
TEST_TIME 117 5802.38 0.9956 1.0079 1351 65
TEST_TIME 118 5813.55 0.9974 1.0035 1233 76
TEST_TIME 119 5825.35 0.9931 1.0051 997 89
TEST_TIME 120 5824.35 0.9969 1.0018 1270 94
TEST_TIME 121 5812.67 0.9955 1.0036 1198 97
TEST_TIME 122 5810.08 0.9958 1.0034 1729 98
TEST_TIME 123 5816.70 0.9941 1.0057 1682 97
TEST_TIME 124 5828.90 0.9955 1.0049 1596 96
TEST_TIME 125 5828.97 0.9968 1.0038 1166 93
TEST_TIME 126 5851.47 0.9940 1.0028 1543 99
TEST_TIME 127 5851.47 0.9965 1.0025 1586 100
TEST_TIME 128 5838.61 0.9968 1.0038 1385 91
TEST_TIME 129 5849.11 0.9942 1.0078 1102 100
TEST_TIME 130 5872.37 0.9960 1.0051 1046 100
TEST_TIME 131 5875.51 0.9969 1.0042 1403 100
TEST_TIME 132 5890.07 0.9941 1.0019 1519 100
TEST_TIME 133 5879.65 0.9961 1.0044 1245 100
TEST_TIME 134 5892.77 0.9947 1.0029 1399 100
TEST_TIME 135 5881.28 0.9974 1.0058 1228 99
TEST_TIME 136 5900.73 0.9952 1.0048 1219 100
TEST_TIME 137 5916.25 0.9948 1.0025 1812 99
TEST_TIME 138 5915.17 0.9954 1.0060 1590 98
TEST_TIME 139 5936.09 0.9952 1.0035 1536 100
TEST_TIME 140 5945.45 0.9948 1.0056 1485 98
TEST_TIME 141 5948.59 0.9979 1.0061 1595 98
TEST_TIME 142 5956.16 0.9977 1.0058 1485 95
TEST_TIME 143 5964.57 0.9973 1.0028 1427 98
TEST_TIME 144 5960.08 0.9966 1.0053 1285 100
TEST_TIME 145 5973.64 0.9961 1.0021 1469 99
TEST_TIME 146 5958.90 0.9977 1.0028 1569 94
TEST_TIME 147 5958.80 0.9960 1.0030 1377 94
TEST_TIME 148 5958.60 0.9963 1.0037 1343 98
TEST_TIME 149 5969.55 0.9951 1.0025 1328 98
TEST_TIME 150 5977.91 0.9975 1.0020 1277 99
TEST_TIME 151 5976.06 0.9957 1.0032 1277 100
TEST_TIME 152 5998.87 0.9928 1.0043 1876 100
TEST_TIME 153 6001.06 0.9974 1.0033 1932 95
TEST_TIME 154 6011.39 0.9951 1.0030 2023 91
TEST_TIME 155 6022.70 0.9947 1.0052 1608 94
TEST_TIME 156 6030.57 0.9974 1.0018 1696 99
TEST_TIME 157 6019.73 0.9973 1.0034 1706 89
TEST_TIME 158 6027.56 0.9958 1.0037 1258 94
TEST_TIME 159 6025.02 0.9978 1.0028 1282 93
TEST_TIME 160 6022.77 0.9969 1.0051 1260 97
TEST_TIME 161 6023.98 0.9987 1.0018 1418 95
TEST_TIME 162 6019.19 0.9964 1.0056 1256 96
TEST_TIME 163 6021.41 0.9990 1.0008 1298 95
TEST_TIME 164 5995.75 0.9990 1.0011 1173 69
TEST_TIME 165 5983.99 0.9970 1.0048 814 96
TEST_TIME 166 5999.98 0.9961 1.0040 1165 100
TEST_TIME 167 6005.17 0.9971 1.0024 1749 100
TEST_TIME 168 6003.48 0.9967 1.0033 2150 95
TEST_TIME 169 6008.00 0.9966 1.0032 1805 90
TEST_TIME 170 6021.17 0.9951 1.0048 1541 99
TEST_TIME 171 6035.65 0.9965 1.0027 1718 100
TEST_TIME 172 6032.54 0.9974 1.0018 1622 98
TEST_TIME 173 6027.03 0.9969 1.0054 1683 96
TEST_TIME 174 6033.43 0.9986 1.0020 1627 96
TEST_TIME 175 6027.71 0.9972 1.0028 1638 94
TEST_TIME 176 6025.98 0.9974 1.0022 1448 96
TEST_TIME 177 6021.33 0.9974 1.0026 1334 88
TEST_TIME 178 6021.26 0.9969 1.0025 1315 83
TEST_TIME 179 6029.83 0.9954 1.0022 1140 86
TEST_TIME 180 6010.39 0.9999 1.0008 72 72
Done for 10650 ms, from 11:40:06.86 to 11:40:17.51.

Performance from TRACE for ISQL instance #1:

TRACED_DATA ITRV_NO SP_CLIENT_ORDER SP_CANCEL_CLIENT_ORDER SP_SUPPLIER_ORDER SP_CANCEL_SUPPLIER_ORDER SP_SUPPLIER_INVOICE SP_CANCEL_SUPPLIER_INVOICE SP_ADD_INVOICE_TO_STOCK SP_CANCEL_ADDING_INVOICE SP_CUSTOMER_RESERVE SP_CANCEL_CUSTOMER_RESERVE SP_RESERVE_WRITE_OFF SP_CANCEL_WRITE_OFF SP_PAY_FROM_CUSTOMER SP_CANCEL_PAY_FROM_CUSTOMER SP_PAY_TO_SUPPLIER SP_CANCEL_PAY_TO_SUPPLIER SRV_MAKE_INVNT_SALDO SRV_MAKE_MONEY_SALDO SRV_RECALC_IDX_STAT ITRV_BEG ITRV_END
fetches per second 1 21783 10676 23422 <null> 22295 <null> 22029 10506 14447 3426 25191 15930 35456 1351 34080 27307 32216 43534 <null> 08:24:01 08:42:01
fetches per second 2 2743 3023 4510 <null> 19329 6429 8947 <null> 3899 4137 3198 <null> 6776 6646 7076 2216 <null> 62920 <null> 08:42:02 09:00:02
fetches per second 3 6098 4260 11088 <null> 12516 4800 13306 30020 4656 8794 14589 6634 21308 26314 10364 <null> <null> 93109 <null> 09:00:03 09:18:03
fetches per second 4 15985 17240 13113 <null> 14127 64147 17553 44329 18769 <null> 16825 4061 10355 24381 24314 1411 26589 13680 <null> 09:18:04 09:36:04
fetches per second 5 7056 24768 5416 <null> 4590 <null> 8126 11974 10768 39948 6473 3090 10874 7292 14537 <null> <null> 73949 <null> 09:36:05 09:54:05
fetches per second 6 19203 34186 12502 <null> 17917 <null> 29502 8579 51344 5162 39468 8814 28537 128875 30155 117375 24170 112046 <null> 09:54:06 10:12:06
fetches per second 7 9101 2956 11620 <null> 5073 <null> 14753 3710 148235 4160 4004 <null> 10869 3799 21001 1215 <null> 73722 <null> 10:12:07 10:30:07
fetches per second 8 17302 15568 7562 <null> 22719 2820 24574 3487 73300 3108 15579 2643 19719 5285 32854 16812 38710 109478 <null> 10:30:08 10:48:08
fetches per second 9 12508 10825 25152 <null> 9817 3694 39360 6795 4896 4078 9778 2316 19990 12007 20614 <null> 233122 62805 <null> 10:48:09 11:06:09
fetches per second 10 5719 6283 5103 <null> 5967 2526 4588 5885 787 41153 7009 8444 10528 3990 6233 <null> <null> 129972 <null> 11:06:10 11:24:10
marks per second 1 4870 1389 4841 <null> 4736 <null> 2758 2165 1726 629 4050 2745 3929 197 1320 4173 1321 538 <null> 08:24:01 08:42:01
marks per second 2 588 370 816 <null> 3693 1633 1451 <null> 642 862 630 <null> 527 1143 636 409 <null> 1761 <null> 08:42:02 09:00:02
marks per second 3 1303 516 1823 <null> 2611 1166 1741 5023 556 1652 2491 1331 808 4032 581 <null> <null> 1072 <null> 09:00:03 09:18:03
marks per second 4 3514 2419 2812 <null> 2885 13482 2821 7588 2141 <null> 3264 646 490 3604 1808 250 849 608 <null> 09:18:04 09:36:04
marks per second 5 1513 3017 881 <null> 835 <null> 1138 1957 1540 6378 964 502 473 1199 1540 <null> <null> 1622 <null> 09:36:05 09:54:05
marks per second 6 4153 4202 2261 <null> 3700 <null> 4456 1397 9170 827 4421 1460 1254 23204 3544 23875 973 4015 <null> 09:54:06 10:12:06
marks per second 7 2016 428 2089 <null> 795 <null> 1813 619 24235 916 595 <null> 616 679 2658 183 <null> 3141 <null> 10:12:07 10:30:07
marks per second 8 3683 2262 1401 <null> 4372 748 3409 702 13300 691 1560 446 884 800 3665 2724 6442 18251 <null> 10:30:08 10:48:08
marks per second 9 2492 1552 3486 <null> 1349 876 5006 1119 661 730 2044 368 884 1481 1429 <null> 2603 728 <null> 10:48:09 11:06:09
marks per second 10 1205 877 649 <null> 880 582 617 965 110 7541 647 992 374 701 810 <null> <null> 791 <null> 11:06:10 11:24:10
reads/fetches*100 1 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 08:24:01 08:42:01
reads/fetches*100 2 0 0 0 <null> 0 0 0 <null> 0 0 0 <null> 0 0 0 0 <null> 0 <null> 08:42:02 09:00:02
reads/fetches*100 3 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 09:00:03 09:18:03
reads/fetches*100 4 0 0 0 <null> 0 0 0 0 0 <null> 0 0 0 0 0 0 0 0 <null> 09:18:04 09:36:04
reads/fetches*100 5 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 09:36:05 09:54:05
reads/fetches*100 6 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 <null> 09:54:06 10:12:06
reads/fetches*100 7 0 0 0 <null> 0 <null> 0 0 0 0 0 <null> 0 0 0 0 <null> 0 <null> 10:12:07 10:30:07
reads/fetches*100 8 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 0 0 0 <null> 10:30:08 10:48:08
reads/fetches*100 9 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> 0 0 <null> 10:48:09 11:06:09
reads/fetches*100 10 0 0 0 <null> 0 0 0 0 0 0 0 0 0 0 0 <null> <null> 0 <null> 11:06:10 11:24:10
writes/marks*100 1 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 4 0 <null> 08:24:01 08:42:01
writes/marks*100 2 0 0 0 <null> 0 0 0 <null> 0 0 0 <null> 0 0 0 0 <null> 0 <null> 08:42:02 09:00:02
writes/marks*100 3 0 0 1 <null> 0 0 0 0 1 1 0 0 0 0 0 <null> <null> 0 <null> 09:00:03 09:18:03
writes/marks*100 4 0 0 0 <null> 0 0 0 0 1 <null> 0 0 0 0 0 0 1 0 <null> 09:18:04 09:36:04
writes/marks*100 5 1 0 0 <null> 0 <null> 0 0 1 0 0 0 0 0 0 <null> <null> 0 <null> 09:36:05 09:54:05
writes/marks*100 6 0 0 0 <null> 0 <null> 0 0 0 0 0 0 0 0 0 0 2 0 <null> 09:54:06 10:12:06
writes/marks*100 7 0 1 1 <null> 0 <null> 0 0 0 0 0 <null> 0 0 0 0 <null> 0 <null> 10:12:07 10:30:07
writes/marks*100 8 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 0 2 0 <null> 10:30:08 10:48:08
writes/marks*100 9 0 0 0 <null> 0 0 0 0 1 0 0 0 0 0 0 <null> 5 0 <null> 10:48:09 11:06:09
writes/marks*100 10 0 0 0 <null> 0 0 0 0 1 1 0 0 0 0 0 <null> <null> 0 <null> 11:06:10 11:24:10
Done for 9530 ms, from 11:40:18.71 to 11:40:28.24.

Performance in DETAILS:

UNIT CNT_ALL CNT_OK CNT_ERR ERR_PRC OK_MIN_MS OK_MAX_MS OK_AVG_MS CNT_LK_CONFL JOB_BEG JOB_END
doc_list_aiud 1873668 1758920 114748 6.12 0 20733 59 114748 2017-03-29 08:24 2017-03-29 11:24
doc_list_biud 1874069 1758920 115149 6.14 0 17893 21 115149 2017-03-29 08:24 2017-03-29 11:24
sp_add_invoice_to_stock 19936 12294 7642 38.33 15 168917 15662 7642 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_adding_invoice 4270 3382 888 20.79 0 87329 3420 888 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_client_order 6838 6680 158 2.31 0 3760 296 158 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_customer_reserve 290453 185277 105176 36.21 0 17893 90 105176 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_pay_from_customer 2645 2638 7 0.26 0 2231 149 7 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_pay_to_supplier 1615 1610 5 0.30 0 3307 149 5 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_supplier_invoice 9051 7170 1881 20.78 0 11326 585 1881 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_supplier_order 1585 522 1063 67.06 47 439234 27981 1063 2017-03-29 08:24 2017-03-29 11:24
sp_cancel_write_off 22651 14758 7893 34.84 0 5117 205 7893 2017-03-29 08:24 2017-03-29 11:24
sp_client_order 81074 81074 0 0.00 0 16380 565 0 2017-03-29 08:24 2017-03-29 11:24
sp_customer_reserve 632395 632395 0 0.00 0 18657 258 0 2017-03-29 08:24 2017-03-29 11:24
sp_fill_shopping_cart 123261 123012 249 0.20 0 7005 113 0 2017-03-29 08:24 2017-03-29 11:24
sp_fill_shopping_cart_clo_res 632395 632395 0 0.00 0 16989 19 0 2017-03-29 08:24 2017-03-29 11:24
sp_get_clo_for_invoice 12294 12294 0 0.00 0 4789 387 0 2017-03-29 08:24 2017-03-29 11:24
sp_kill_cost_storno 30779 22388 8391 27.26 0 2824 22 8391 2017-03-29 08:24 2017-03-29 11:24
sp_kill_qstorno_ret_qs2qd 612276 393004 219272 35.81 0 17877 34 219272 2017-03-29 08:24 2017-03-29 11:24
sp_kill_qty_storno 382947 267891 115056 30.04 0 17893 99 115056 2017-03-29 08:24 2017-03-29 11:24
sp_lock_selected_doc 80589 70077 10512 13.04 0 2091 8 10512 2017-03-29 08:24 2017-03-29 11:24
sp_make_cost_storno 100097 100097 0 0.00 0 19968 477 0 2017-03-29 08:24 2017-03-29 11:24
sp_multiply_rows_for_pdistr 100097 100097 0 0.00 0 19890 63 0 2017-03-29 08:24 2017-03-29 11:24
sp_multiply_rows_for_qdistr 81074 81074 0 0.00 0 15912 190 0 2017-03-29 08:24 2017-03-29 11:24
sp_pay_from_customer 27399 27399 0 0.00 15 20077 1064 0 2017-03-29 08:24 2017-03-29 11:24
sp_pay_to_supplier 22596 22596 0 0.00 0 18501 764 0 2017-03-29 08:24 2017-03-29 11:24
sp_payment_common 49995 49995 0 0.00 0 17768 67 0 2017-03-29 08:24 2017-03-29 11:24
sp_qd_handle_on_cancel_clo 6832 6680 152 2.22 0 3416 133 152 2017-03-29 08:24 2017-03-29 11:24
sp_qd_handle_on_invoice_upd_sts 16359 15676 683 4.17 0 17301 421 683 2017-03-29 08:24 2017-03-29 11:24
sp_qd_handle_on_reserve_upd_sts 37808 37808 0 0.00 0 4695 66 0 2017-03-29 08:24 2017-03-29 11:24
sp_reserve_write_off 38474 37808 666 1.73 0 20826 588 666 2017-03-29 08:24 2017-03-29 11:24
sp_supplier_invoice 21024 20925 99 0.47 0 25491 3489 0 2017-03-29 08:24 2017-03-29 11:24
sp_supplier_order 21163 21013 150 0.70 0 20608 2455 0 2017-03-29 08:24 2017-03-29 11:24
srv_find_qd_qs_mism 1101034 986284 114750 10.42 0 17488 34 114750 2017-03-29 08:24 2017-03-29 11:24
srv_make_invnt_saldo 1398 1398 0 0.00 0 24024 4685 0 2017-03-29 08:24 2017-03-29 11:24
srv_make_money_saldo 3797 3797 0 0.00 0 3463 63 0 2017-03-29 08:24 2017-03-29 11:24
srv_recalc_idx_stat 12 12 0 0.00 2371 34351 17217 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_add_invoice_to_stock 7642 7642 0 0.00 0 2309 101 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_adding_invoice 792 792 0 0.00 0 1747 223 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_client_order 158 158 0 0.00 0 1389 111 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_customer_reserve 49 49 0 0.00 0 748 75 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_pay_from_customer 7 7 0 0.00 0 172 73 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_pay_to_supplier 5 5 0 0.00 32 265 99 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_supplier_invoice 603 603 0 0.00 0 1030 82 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_supplier_order 13227 13227 0 0.00 0 17753 163 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_cancel_write_off 36 36 0 0.00 0 562 87 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_reserve_write_off 666 666 0 0.00 0 1966 85 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_supplier_invoice 99 99 0 0.00 0 655 87 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-abend:sp_supplier_order 150 150 0 0.00 0 3760 150 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_add_invoice_to_stock 12294 12294 0 0.00 0 11700 759 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_adding_invoice 1365 1365 0 0.00 0 8658 846 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_client_order 6680 6680 0 0.00 0 2075 69 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_customer_reserve 2525 2525 0 0.00 0 2372 62 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_pay_from_customer 2638 2638 0 0.00 0 2168 56 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_pay_to_supplier 1610 1610 0 0.00 0 1638 51 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_supplier_invoice 957 957 0 0.00 0 2184 91 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_supplier_order 522 522 0 0.00 0 30997 2257 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_cancel_write_off 3678 3678 0 0.00 0 2168 78 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_client_order 81074 81074 0 0.00 0 3104 85 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_customer_reserve 3744 3744 0 0.00 0 2106 62 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_pay_from_customer 27399 27399 0 0.00 0 11700 77 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_pay_to_supplier 22596 22596 0 0.00 0 2730 67 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_reserve_write_off 37808 37808 0 0.00 0 6287 77 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_supplier_invoice 20925 20925 0 0.00 0 13275 81 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:sp_supplier_order 21013 21013 0 0.00 0 2512 87 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:srv_make_invnt_saldo 1398 1398 0 0.00 0 1295 34 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:srv_make_money_saldo 3797 3797 0 0.00 0 1107 25 0 2017-03-29 08:24 2017-03-29 11:24
t$perf-norm:srv_recalc_idx_stat 12 12 0 0.00 0 795 166 0 2017-03-29 08:24 2017-03-29 11:24
v_add_invoice_to_stock 39872 24588 15284 38.33 0 6739 47 15284 2017-03-29 08:24 2017-03-29 11:24
v_all_customers 121762 121762 0 0.00 0 1560 6 0 2017-03-29 08:24 2017-03-29 11:24
v_all_suppliers 84646 84148 498 0.58 0 999 6 0 2017-03-29 08:24 2017-03-29 11:24
v_all_wares 162148 162148 0 0.00 0 4930 5 0 2017-03-29 08:24 2017-03-29 11:24
v_cancel_adding_invoice 3296 2730 566 17.17 0 2168 165 566 2017-03-29 08:24 2017-03-29 11:24
v_cancel_client_order 13676 13360 316 2.31 0 842 7 316 2017-03-29 08:24 2017-03-29 11:24
v_cancel_customer_prepayment 5290 5276 14 0.26 0 655 9 14 2017-03-29 08:24 2017-03-29 11:24
v_cancel_customer_reserve 5148 5050 98 1.90 0 749 9 98 2017-03-29 08:24 2017-03-29 11:24
v_cancel_payment_to_supplier 3230 3220 10 0.30 0 375 9 10 2017-03-29 08:24 2017-03-29 11:24
v_cancel_supplier_invoice 3120 1914 1206 38.65 0 1154 45 1206 2017-03-29 08:24 2017-03-29 11:24
v_cancel_supplier_order 3170 1044 2126 67.06 0 374 11 2126 2017-03-29 08:24 2017-03-29 11:24
v_cancel_write_off 7428 7356 72 0.96 0 3323 100 72 2017-03-29 08:24 2017-03-29 11:24
v_max_id_clo_ord 21163 21013 150 0.70 0 889 6 0 2017-03-29 08:24 2017-03-29 11:24
v_max_id_clo_res 3744 3744 0 0.00 0 967 19 0 2017-03-29 08:24 2017-03-29 11:24
v_max_id_ord_sup 21024 20925 99 0.47 0 873 6 0 2017-03-29 08:24 2017-03-29 11:24
v_max_non_paid_invoice 22460 22460 0 0.00 0 17753 7 0 2017-03-29 08:24 2017-03-29 11:24
v_max_non_paid_realizn 27399 27399 0 0.00 0 1076 6 0 2017-03-29 08:24 2017-03-29 11:24
v_min_id_clo_ord 21163 21013 150 0.70 0 1497 8 0 2017-03-29 08:24 2017-03-29 11:24
v_min_id_clo_res 3744 3744 0 0.00 0 1138 11 0 2017-03-29 08:24 2017-03-29 11:24
v_min_id_ord_sup 21024 20925 99 0.47 0 1248 8 0 2017-03-29 08:24 2017-03-29 11:24
v_min_non_paid_invoice 22596 22596 0 0.00 0 3759 8 0 2017-03-29 08:24 2017-03-29 11:24
v_min_non_paid_realizn 27399 27399 0 0.00 0 3322 7 0 2017-03-29 08:24 2017-03-29 11:24
v_our_firm 40386 40386 0 0.00 0 1607 7 0 2017-03-29 08:24 2017-03-29 11:24
v_reserve_write_off 76948 75616 1332 1.73 0 16817 9 1332 2017-03-29 08:24 2017-03-29 11:24
x_lock_depdocs_on_canc_invoice 17295 9595 7700 44.52 0 1779 41 7700 2017-03-29 08:24 2017-03-29 11:24
x_lock_depdocs_on_canc_sup_ord 1582 522 1060 67.00 0 1280 81 1060 2017-03-29 08:24 2017-03-29 11:24
x_make_qstorno_1000_1200 21163 21013 150 0.70 0 20421 2205 0 2017-03-29 08:24 2017-03-29 11:24
x_make_qstorno_1200_2000 21024 20925 99 0.47 0 25272 3240 0 2017-03-29 08:24 2017-03-29 11:24
x_make_qstorno_2100_3300 632395 632395 0 0.00 0 18610 218 0 2017-03-29 08:24 2017-03-29 11:24
Done for 458660 ms, from 11:47:47.99 to 11:55:26.65.

Config param. mon_unit_perf=0, data from MON$ tables were NOT gathered.

Exceptions occured during test work:

FB_MNEMONA CNT UNIT FB_GDSCODE DTS_BEG DTS_END
deadlock 106 sp_kill_cost_storno 335544336 2017-03-29 08:24 2017-03-29 11:23
deadlock 73 sp_kill_qstorno_ret_qs2qd 335544336 2017-03-29 08:28 2017-03-29 11:22
deadlock 1272 sp_lock_selected_doc 335544336 2017-03-29 08:24 2017-03-29 11:23
deadlock 152 sp_qd_handle_on_cancel_clo 335544336 2017-03-29 08:24 2017-03-29 11:23
deadlock 145 sp_qd_handle_on_invoice_upd_sts 335544336 2017-03-29 08:24 2017-03-29 11:22
deadlock 29 x_lock_depdocs_on_canc_invoice 335544336 2017-03-29 08:24 2017-03-29 10:55
deadlock 7 x_lock_depdocs_on_canc_sup_ord 335544336 2017-03-29 09:12 2017-03-29 10:34
user_exc 150 x_make_qstorno_1000_1200 335544517 2017-03-29 08:24 2017-03-29 11:23
user_exc 99 x_make_qstorno_1200_2000 335544517 2017-03-29 08:24 2017-03-29 11:23
concurrent_transaction 7749 sp_lock_selected_doc 335544878 2017-03-29 08:24 2017-03-29 11:24
concurrent_transaction 649 x_lock_depdocs_on_canc_invoice 335544878 2017-03-29 08:24 2017-03-29 11:24
concurrent_transaction 326 x_lock_depdocs_on_canc_sup_ord 335544878 2017-03-29 08:28 2017-03-29 11:23
Done for 12900 ms, from 11:55:36.99 to 11:55:49.89.

MON$DATABASE and FB VERSION info

MON$DATABASE_NAME D:\OLTP-EMUL\OLTP40-SMALL.FDB
MON$PAGE_SIZE 8192
MON$ODS_MAJOR 13
MON$ODS_MINOR 0
MON$OLDEST_TRANSACTION 431134
MON$OLDEST_ACTIVE 431135
MON$OLDEST_SNAPSHOT 431135
MON$NEXT_TRANSACTION 431135
MON$PAGE_BUFFERS 786432
MON$SQL_DIALECT 3
MON$SHUTDOWN_MODE 0
MON$SWEEP_INTERVAL 0
MON$READ_ONLY 0
MON$FORCED_WRITES 1
MON$RESERVE_SPACE 1
MON$CREATION_DATE 2017-01-11 15:15:54.2050
MON$PAGES 852672
MON$STAT_ID 1
MON$BACKUP_STATE 0
MON$CRYPT_PAGE 0
MON$OWNER SYSDBA
MON$SEC_DATABASE Default
ISQL Version: WI-T4.0.0.578 Firebird 4.0 Unstable
Server version:
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-T4.0.0.578 Firebird 4.0 Unstable"
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-T4.0.0.578 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-T4.0.0.578 Firebird 4.0 Unstable/tcp (WIN-2BE1UI8LGDL)/P16"
on disk structure version 13.0

Database statistics, full


Database "D:\OLTP-EMUL\OLTP40-SMALL.FDB"
Database header page information:
Flags 0
Generation 431210
System Change Number 0
Page size 8192
ODS version 13.0
Oldest transaction 431136
Oldest active 431137
Oldest snapshot 431137
Next transaction 431138
Sequence number 0
Next attachment ID 9360
Implementation HW=AMD/Intel/x64 little-endian OS=Windows CC=MSVC
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3
Creation date Jan 11, 2017 15:15:54
Attributes force write

Variable header data:
Sweep interval: 0
*END*


Database file sequence:
File D:\OLTP-EMUL\OLTP40-SMALL.FDB is the only file

Analyzing database pages ...
AGENTS (154)
Primary pointer page: 314, Index root page: 315
Total formats: 1, used formats: 1
Average record length: 33.50, total records: 50
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 344.00, compression ratio: 10.27
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 31%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_ID_DESC (2)
Root page: 325, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_OUR_FIRM (4)
Root page: 327, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 48
Average key length: 2.04, compression ratio: 0.50
Average prefix length: 0.96, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_IS_SUPPLIER (3)
Root page: 326, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 3.08, total dup: 48, max dup: 43
Average key length: 2.04, compression ratio: 0.55
Average prefix length: 1.06, average data length: 0.06
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index AGENTS_NAME_UNQ (1)
Root page: 324, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 17.32, total dup: 0, max dup: 0
Average key length: 15.94, compression ratio: 0.91
Average prefix length: 1.20, average data length: 13.32
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_AGENTS (0)
Root page: 323, depth: 1, leaf buckets: 1, nodes: 50
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

BUSINESS_OPS (158)
Primary pointer page: 335, Index root page: 336
Total formats: 1, used formats: 1
Average record length: 107.00, total records: 19
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1236.00, compression ratio: 11.55
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 29%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BO_UNIT_UNQ (1)
Root page: 339, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 18.00, total dup: 0, max dup: 0
Average key length: 16.95, compression ratio: 1.25
Average prefix length: 7.21, average data length: 14.00
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index BUSINESS_OPS_RND_WGTH (2)
Root page: 340, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 4.05, total dup: 7, max dup: 3
Average key length: 3.00, compression ratio: 0.75
Average prefix length: 1.42, average data length: 0.84
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RDB$1 (0)
Root page: 338, depth: 1, leaf buckets: 1, nodes: 19
Average node length: 5.26, total dup: 0, max dup: 0
Average key length: 4.21, compression ratio: 0.64
Average prefix length: 1.05, average data length: 1.63
Clustering factor: 1, ratio: 0.05
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

DOC_DATA (141)
Primary pointer page: 254, Index root page: 255
Total formats: 1, used formats: 1
Average record length: 47.12, total records: 2156606
Average version length: 47.73, total versions: 2615, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.36
Pointer pages: 15, data page slots: 23480
Data pages: 23480, average fill: 72%
Primary pages: 23480, secondary pages: 0, swept pages: 15410
Empty pages: 5, full pages: 18142
Fill distribution:
0 - 19% = 6
20 - 39% = 5
40 - 59% = 126
60 - 79% = 23340
80 - 99% = 3

Index DOC_DATA_DOC_WARE_UNQ (1)
Root page: 26714, depth: 3, leaf buckets: 10538, nodes: 2156606
Average node length: 19.43, total dup: 0, max dup: 0
Average key length: 16.47, compression ratio: 1.64
Average prefix length: 13.52, average data length: 13.48
Clustering factor: 513103, ratio: 0.24
Fill distribution:
0 - 19% = 592
20 - 39% = 2255
40 - 59% = 5445
60 - 79% = 907
80 - 99% = 1339

Index DOC_DATA_ID_DESC (2)
Root page: 46473, depth: 3, leaf buckets: 7729, nodes: 2156606
Average node length: 11.64, total dup: 0, max dup: 0
Average key length: 8.69, compression ratio: 1.04
Average prefix length: 3.31, average data length: 5.69
Clustering factor: 474610, ratio: 0.22
Fill distribution:
0 - 19% = 0
20 - 39% = 3644
40 - 59% = 4046
60 - 79% = 35
80 - 99% = 4

Index FK_DOC_DATA_DOC_LIST (3)
Root page: 175220, depth: 3, leaf buckets: 3936, nodes: 2156606
Average node length: 6.88, total dup: 1550464, max dup: 49
Average key length: 3.93, compression ratio: 2.29
Average prefix length: 7.35, average data length: 1.65
Clustering factor: 474836, ratio: 0.22
Fill distribution:
0 - 19% = 141
20 - 39% = 1417
40 - 59% = 1751
60 - 79% = 114
80 - 99% = 513

DOC_LIST (140)
Primary pointer page: 249, Index root page: 250
Total formats: 1, used formats: 1
Average record length: 60.35, total records: 671418
Average version length: 61.31, total versions: 241, max versions: 2
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 1.59
Pointer pages: 6, data page slots: 8552
Data pages: 8552, average fill: 75%
Primary pages: 8551, secondary pages: 1, swept pages: 8240
Empty pages: 7, full pages: 7251
Fill distribution:
0 - 19% = 10
20 - 39% = 6
40 - 59% = 39
60 - 79% = 8484
80 - 99% = 13

Index DOC_LIST_ID_DESC (1)
Root page: 259256, depth: 3, leaf buckets: 2509, nodes: 671418
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.18, average data length: 5.82
Clustering factor: 170182, ratio: 0.25
Fill distribution:
0 - 19% = 0
20 - 39% = 1485
40 - 59% = 1007
60 - 79% = 16
80 - 99% = 1

Index FK_DOC_LIST_AGENTS (2)
Root page: 2940, depth: 2, leaf buckets: 714, nodes: 671418
Average node length: 4.88, total dup: 671368, max dup: 34555
Average key length: 2.01, compression ratio: 4.48
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 304850, ratio: 0.45
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 615
60 - 79% = 81
80 - 99% = 17

Index PK_DOC_LIST (0)
Root page: 308341, depth: 3, leaf buckets: 2206, nodes: 671418
Average node length: 11.68, total dup: 0, max dup: 0
Average key length: 8.81, compression ratio: 1.02
Average prefix length: 3.19, average data length: 5.81
Clustering factor: 170182, ratio: 0.25
Fill distribution:
0 - 19% = 158
20 - 39% = 905
40 - 59% = 785
60 - 79% = 133
80 - 99% = 225

DOC_STATES (153)
Primary pointer page: 312, Index root page: 313
Total formats: 1, used formats: 1
Average record length: 67.50, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 650.00, compression ratio: 9.63
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_MCODE_UNQ (1)
Root page: 321, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 17.75, total dup: 0, max dup: 0
Average key length: 16.50, compression ratio: 1.08
Average prefix length: 4.00, average data length: 13.75
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index DOC_STATES_NAME_UNQ (2)
Root page: 322, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 33.25, total dup: 0, max dup: 0
Average key length: 32.00, compression ratio: 0.99
Average prefix length: 2.50, average data length: 29.25
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_DOC_STATES (0)
Root page: 320, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 4.75, total dup: 0, max dup: 0
Average key length: 3.50, compression ratio: 0.86
Average prefix length: 1.50, average data length: 1.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

FB_ERRORS (159)
Primary pointer page: 341, Index root page: 342
Total formats: 1, used formats: 1
Average record length: 79.56, total records: 758
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 148.00, compression ratio: 1.86
Pointer pages: 1, data page slots: 16
Data pages: 16, average fill: 56%
Primary pages: 16, secondary pages: 0, swept pages: 0
Empty pages: 4, full pages: 11
Fill distribution:
0 - 19% = 5
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 7

Index FB_ERRORS_GDS_CODE (0)
Root page: 343, depth: 1, leaf buckets: 1, nodes: 758
Average node length: 4.24, total dup: 0, max dup: 0
Average key length: 3.04, compression ratio: 1.64
Average prefix length: 3.97, average data length: 1.03
Clustering factor: 353, ratio: 0.47
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

INVNT_SALDO (147)
Primary pointer page: 273, Index root page: 274
Total formats: 1, used formats: 1
Average record length: 65.83, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 18.25, total fragments: 377, max fragments: 1
Average unpacked length: 104.00, compression ratio: 1.58
Pointer pages: 1, data page slots: 696
Data pages: 20, average fill: 32%
Primary pages: 5, secondary pages: 15, swept pages: 4
Empty pages: 7, full pages: 3
Fill distribution:
0 - 19% = 10
20 - 39% = 3
40 - 59% = 3
60 - 79% = 1
80 - 99% = 3

Index PK_INVNT_SALDO (0)
Root page: 285, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 303, ratio: 0.76
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

INVNT_TURNOVER_LOG (157)
Primary pointer page: 333, Index root page: 334
Total formats: 1, used formats: 1
Average record length: 41.27, total records: 6514
Average version length: 71.25, total versions: 2742, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 96.00, compression ratio: 2.33
Pointer pages: 2, data page slots: 1840
Data pages: 592, average fill: 15%
Primary pages: 592, secondary pages: 0, swept pages: 476
Empty pages: 88, full pages: 25
Fill distribution:
0 - 19% = 446
20 - 39% = 74
40 - 59% = 33
60 - 79% = 29
80 - 99% = 10

Index INVNT_TURNOVER_LOG_WARE_DD_ID (0)
Root page: 1481, depth: 2, leaf buckets: 33, nodes: 6514
Average node length: 15.45, total dup: 279, max dup: 1
Average key length: 12.52, compression ratio: 2.16
Average prefix length: 17.44, average data length: 9.56
Clustering factor: 5276, ratio: 0.81
Fill distribution:
0 - 19% = 1
20 - 39% = 20
40 - 59% = 11
60 - 79% = 1
80 - 99% = 0

MONEY_SALDO (143)
Primary pointer page: 265, Index root page: 266
Total formats: 1, used formats: 1
Average record length: 15.04, total records: 49
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 2.13
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 20%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MONEY_SALDO (0)
Root page: 276, depth: 1, leaf buckets: 1, nodes: 49
Average node length: 11.82, total dup: 0, max dup: 0
Average key length: 10.80, compression ratio: 0.83
Average prefix length: 1.18, average data length: 7.82
Clustering factor: 1, ratio: 0.02
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MONEY_TURNOVER_LOG (142)
Primary pointer page: 263, Index root page: 264
Total formats: 1, used formats: 1
Average record length: 46.29, total records: 38
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 1.38
Pointer pages: 1, data page slots: 64
Data pages: 24, average fill: 2%
Primary pages: 24, secondary pages: 0, swept pages: 18
Empty pages: 20, full pages: 0
Fill distribution:
0 - 19% = 23
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0)
Root page: 214941, depth: 2, leaf buckets: 1, nodes: 38
Average node length: 12.61, total dup: 19, max dup: 6
Average key length: 10.58, compression ratio: 1.80
Average prefix length: 10.89, average data length: 8.11
Clustering factor: 12, ratio: 0.32
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG (165)
Primary pointer page: 356, Index root page: 357
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_DTS (4)
Root page: 367, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_GDSCODE (2)
Root page: 365, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_ROWSET_DESC (1)
Root page: 364, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_UNIT (3)
Root page: 366, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG (0)
Root page: 363, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

MON_LOG_TABLE_STATS (166)
Primary pointer page: 369, Index root page: 370
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_DTS (4)
Root page: 376, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_GDSCODE (2)
Root page: 374, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_ROWSET (1)
Root page: 373, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index MON_LOG_TABLE_STATS_TN_UNIT (3)
Root page: 375, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_MON_LOG_TABLE_STATS (0)
Root page: 372, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

OPTYPES (138)
Primary pointer page: 241, Index root page: 242
Total formats: 1, used formats: 1
Average record length: 67.89, total records: 9
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 5.54
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 9%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index OPTYPES_MCODE_UNQ (1)
Root page: 244, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 8.56, total dup: 0, max dup: 0
Average key length: 6.89, compression ratio: 0.73
Average prefix length: 0.44, average data length: 4.56
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_OPTYPES (0)
Root page: 243, depth: 1, leaf buckets: 1, nodes: 9
Average node length: 6.11, total dup: 0, max dup: 0
Average key length: 5.00, compression ratio: 0.60
Average prefix length: 0.89, average data length: 2.11
Clustering factor: 1, ratio: 0.11
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PDISTR (150)
Primary pointer page: 296, Index root page: 297
Total formats: 1, used formats: 1
Average record length: 18.78, total records: 812568
Average version length: 42.71, total versions: 1083, max versions: 6
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 64.00, compression ratio: 3.41
Pointer pages: 4, data page slots: 4944
Data pages: 4944, average fill: 73%
Primary pages: 4938, secondary pages: 6, swept pages: 4552
Empty pages: 5, full pages: 3792
Fill distribution:
0 - 19% = 12
20 - 39% = 58
40 - 59% = 179
60 - 79% = 4356
80 - 99% = 339

Index PDISTR_AGENT_ID (4)
Root page: 3976, depth: 2, leaf buckets: 255, nodes: 238491
Average node length: 4.88, total dup: 238442, max dup: 14947
Average key length: 2.01, compression ratio: 4.47
Average prefix length: 8.99, average data length: 0.01
Clustering factor: 34209, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 29
40 - 59% = 140
60 - 79% = 70
80 - 99% = 15

Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2)
Root page: 3600, depth: 2, leaf buckets: 297, nodes: 238491
Average node length: 5.82, total dup: 215187, max dup: 30
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 38319, ratio: 0.16
Fill distribution:
0 - 19% = 1
20 - 39% = 45
40 - 59% = 127
60 - 79% = 78
80 - 99% = 46

Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3)
Root page: 3602, depth: 2, leaf buckets: 292, nodes: 238491
Average node length: 5.82, total dup: 215187, max dup: 30
Average key length: 2.95, compression ratio: 7.45
Average prefix length: 21.14, average data length: 0.86
Clustering factor: 38363, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 39
40 - 59% = 123
60 - 79% = 92
80 - 99% = 38

Index PDISTR_SND_ID (1)
Root page: 3001, depth: 2, leaf buckets: 296, nodes: 238491
Average node length: 5.61, total dup: 215187, max dup: 30
Average key length: 2.74, compression ratio: 3.28
Average prefix length: 8.36, average data length: 0.64
Clustering factor: 38381, ratio: 0.16
Fill distribution:
0 - 19% = 0
20 - 39% = 48
40 - 59% = 140
60 - 79% = 71
80 - 99% = 37

PERF_ESTIMATED (160)
Primary pointer page: 344, Index root page: 345
Total formats: 1, used formats: 1
Average record length: 27.90, total records: 271624
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 32.00, compression ratio: 1.15
Pointer pages: 2, data page slots: 2320
Data pages: 2320, average fill: 64%
Primary pages: 2320, secondary pages: 0, swept pages: 0
Empty pages: 2, full pages: 2317
Fill distribution:
0 - 19% = 2
20 - 39% = 1
40 - 59% = 0
60 - 79% = 2317
80 - 99% = 0

Index PERF_EST_MINUTE_SINCE_START (0)
Root page: 65315, depth: 2, leaf buckets: 217, nodes: 271624
Average node length: 4.53, total dup: 271443, max dup: 2326
Average key length: 2.00, compression ratio: 1.28
Average prefix length: 2.56, average data length: 0.00
Clustering factor: 51392, ratio: 0.19
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 87
60 - 79% = 65
80 - 99% = 65

PERF_ISQL_STAT (161)
Primary pointer page: 347, Index root page: 348
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PERF_ISQL_STAT_TRN (0)
Root page: 349, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PERF_LOG (163)
Primary pointer page: 352, Index root page: 353
Total formats: 1, used formats: 1
Average record length: 151.84, total records: 11443787
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1696.00, compression ratio: 11.17
Pointer pages: 167, data page slots: 271600
Data pages: 271600, average fill: 87%
Primary pages: 271600, secondary pages: 0, swept pages: 3
Empty pages: 0, full pages: 271599
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 271599

Index PERF_LOG_DTS_BEG_DESC (0)
Root page: 61748, depth: 3, leaf buckets: 12540, nodes: 11443787
Average node length: 5.67, total dup: 10564555, max dup: 156
Average key length: 2.19, compression ratio: 3.65
Average prefix length: 7.86, average data length: 0.14
Clustering factor: 5264718, ratio: 0.46
Fill distribution:
0 - 19% = 14
20 - 39% = 0
40 - 59% = 6234
60 - 79% = 4095
80 - 99% = 2197

Index PERF_LOG_GDSCODE (3)
Root page: 163282, depth: 3, leaf buckets: 11272, nodes: 11443787
Average node length: 4.55, total dup: 11443782, max dup: 10588121
Average key length: 1.08, compression ratio: 0.35
Average prefix length: 0.37, average data length: 0.00
Clustering factor: 343668, ratio: 0.03
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 11243
60 - 79% = 1
80 - 99% = 28

Index PERF_LOG_TRN_DESC (2)
Root page: 42827, depth: 3, leaf buckets: 13619, nodes: 11443787
Average node length: 5.71, total dup: 11078148, max dup: 22023
Average key length: 2.24, compression ratio: 4.02
Average prefix length: 8.80, average data length: 0.20
Clustering factor: 1062746, ratio: 0.09
Fill distribution:
0 - 19% = 6
20 - 39% = 1
40 - 59% = 9568
60 - 79% = 2173
80 - 99% = 1871

Index PERF_LOG_UNIT (1)
Root page: 77433, depth: 3, leaf buckets: 13863, nodes: 11443787
Average node length: 5.55, total dup: 11415117, max dup: 1391645
Average key length: 2.07, compression ratio: 18.23
Average prefix length: 37.69, average data length: 0.07
Clustering factor: 7049326, ratio: 0.62
Fill distribution:
0 - 19% = 19
20 - 39% = 2
40 - 59% = 11845
60 - 79% = 639
80 - 99% = 1358

PHRASES (145)
Primary pointer page: 269, Index root page: 270
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_ID_DESC (3)
Root page: 283, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_NAME (2)
Root page: 282, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PHRASES_UNQ (1)
Root page: 281, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_PHRASES (0)
Root page: 280, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

PSTORNED (151)
Primary pointer page: 303, Index root page: 304
Total formats: 1, used formats: 1
Average record length: 54.98, total records: 429949
Average version length: 55.44, total versions: 999, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 80.00, compression ratio: 1.46
Pointer pages: 4, data page slots: 5144
Data pages: 5144, average fill: 74%
Primary pages: 5144, secondary pages: 0, swept pages: 3649
Empty pages: 3, full pages: 4506
Fill distribution:
0 - 19% = 6
20 - 39% = 9
40 - 59% = 29
60 - 79% = 5096
80 - 99% = 4

Index PSTORNED_RCV_ID (2)
Root page: 667592, depth: 3, leaf buckets: 596, nodes: 429949
Average node length: 5.94, total dup: 361123, max dup: 356
Average key length: 3.16, compression ratio: 2.84
Average prefix length: 7.99, average data length: 1.01
Clustering factor: 53899, ratio: 0.13
Fill distribution:
0 - 19% = 14
20 - 39% = 27
40 - 59% = 420
60 - 79% = 100
80 - 99% = 35

Index PSTORNED_SND_ID (1)
Root page: 2643, depth: 2, leaf buckets: 460, nodes: 429949
Average node length: 5.61, total dup: 382075, max dup: 574
Average key length: 2.83, compression ratio: 3.17
Average prefix length: 8.28, average data length: 0.72
Clustering factor: 102010, ratio: 0.24
Fill distribution:
0 - 19% = 1
20 - 39% = 2
40 - 59% = 188
60 - 79% = 189
80 - 99% = 80

RULES_FOR_PDISTR (152)
Primary pointer page: 305, Index root page: 306
Total formats: 1, used formats: 1
Average record length: 18.00, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 336.00, compression ratio: 18.67
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 2%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_PDISTR_UNQ (0)
Root page: 310, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 11.50, total dup: 0, max dup: 0
Average key length: 10.25, compression ratio: 0.88
Average prefix length: 1.50, average data length: 7.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

RULES_FOR_QDISTR (139)
Primary pointer page: 245, Index root page: 246
Total formats: 1, used formats: 1
Average record length: 32.71, total records: 7
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 332.00, compression ratio: 10.15
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 4%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_RCVOP (1)
Root page: 248, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 5.29, total dup: 2, max dup: 2
Average key length: 4.14, compression ratio: 0.72
Average prefix length: 1.43, average data length: 1.57
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index RULES_FOR_QDISTR_UNQ (0)
Root page: 247, depth: 1, leaf buckets: 1, nodes: 7
Average node length: 10.14, total dup: 0, max dup: 0
Average key length: 8.86, compression ratio: 0.94
Average prefix length: 2.14, average data length: 6.14
Clustering factor: 1, ratio: 0.14
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SEMAPHORES (156)
Primary pointer page: 318, Index root page: 319
Total formats: 1, used formats: 1
Average record length: 34.25, total records: 4
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 338.00, compression ratio: 9.87
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 3%
Primary pages: 1, secondary pages: 0, swept pages: 1
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_SEMAPHORES (0)
Root page: 330, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 12.50, total dup: 0, max dup: 0
Average key length: 11.00, compression ratio: 0.82
Average prefix length: 0.50, average data length: 8.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index SEMAPHORES_TASK_UNQ (1)
Root page: 331, depth: 1, leaf buckets: 1, nodes: 4
Average node length: 22.50, total dup: 0, max dup: 0
Average key length: 21.00, compression ratio: 1.07
Average prefix length: 4.00, average data length: 18.50
Clustering factor: 1, ratio: 0.25
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

SETTINGS (137)
Primary pointer page: 238, Index root page: 239
Total formats: 1, used formats: 1
Average record length: 98.31, total records: 114
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 1347.00, compression ratio: 13.70
Pointer pages: 1, data page slots: 2
Data pages: 2, average fill: 80%
Primary pages: 2, secondary pages: 0, swept pages: 2
Empty pages: 0, full pages: 1
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 1
80 - 99% = 1

Index SETTINGS_MODE_CODE (0)
Root page: 240, depth: 1, leaf buckets: 1, nodes: 114
Average node length: 27.11, total dup: 0, max dup: 0
Average key length: 26.10, compression ratio: 1.70
Average prefix length: 21.18, average data length: 23.11
Clustering factor: 6, ratio: 0.05
Fill distribution:
0 - 19% = 0
20 - 39% = 1
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$RAND$CALLS (136)
Primary pointer page: 236, Index root page: 237
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$AUTOGEN$SOURCE (135)
Primary pointer page: 234, Index root page: 235
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$DEP_DOCS (129)
Primary pointer page: 216, Index root page: 217
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_DEP_DOCS_UNQ (0)
Root page: 218, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$IDX_RECALC (132)
Primary pointer page: 226, Index root page: 227
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_IDX_RECALC_IDX_NAME_UNQ (0)
Root page: 229, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG (133)
Primary pointer page: 230, Index root page: 231
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$MON_LOG_TABLE_STATS (134)
Primary pointer page: 232, Index root page: 233
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_LOG (164)
Primary pointer page: 354, Index root page: 355
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP$PERF_LOG_UNIT_TRN_DTS_END (0)
Root page: 362, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$PERF_MON (131)
Primary pointer page: 224, Index root page: 225
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$RESULT_SET (130)
Primary pointer page: 219, Index root page: 220
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_DOC (1)
Root page: 222, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_RESULT_SET_WARE_DOC (0)
Root page: 221, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TMP$SHOPPING_CART (128)
Primary pointer page: 211, Index root page: 212
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index TMP_SHOPCART_UNQ (0)
Root page: 215, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

TRACE_STAT (162)
Primary pointer page: 350, Index root page: 351
Total formats: 1, used formats: 1
Average record length: 57.90, total records: 2378
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 376.00, compression ratio: 6.49
Pointer pages: 1, data page slots: 32
Data pages: 32, average fill: 68%
Primary pages: 32, secondary pages: 0, swept pages: 0
Empty pages: 3, full pages: 28
Fill distribution:
0 - 19% = 3
20 - 39% = 0
40 - 59% = 1
60 - 79% = 28
80 - 99% = 0

WARES (144)
Primary pointer page: 267, Index root page: 268
Total formats: 1, used formats: 1
Average record length: 77.71, total records: 400
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 448.00, compression ratio: 5.77
Pointer pages: 1, data page slots: 6
Data pages: 6, average fill: 77%
Primary pages: 6, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 5
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 4
80 - 99% = 2

Index FK_WARES_WARE_GROUPS (3)
Root page: 380, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 3.17, total dup: 392, max dup: 65
Average key length: 2.16, compression ratio: 4.16
Average prefix length: 8.86, average data length: 0.14
Clustering factor: 47, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARES (0)
Root page: 277, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_ID_DESC (2)
Root page: 279, depth: 1, leaf buckets: 1, nodes: 400
Average node length: 11.22, total dup: 0, max dup: 0
Average key length: 10.22, compression ratio: 0.88
Average prefix length: 1.78, average data length: 7.22
Clustering factor: 333, ratio: 0.83
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

Index WARES_NUMB_UNQ (1)
Root page: 585, depth: 2, leaf buckets: 4, nodes: 400
Average node length: 52.81, total dup: 0, max dup: 0
Average key length: 51.79, compression ratio: 1.00
Average prefix length: 2.72, average data length: 48.81
Clustering factor: 342, ratio: 0.85
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 1
60 - 79% = 3
80 - 99% = 0

WARE_GROUPS (155)
Primary pointer page: 316, Index root page: 317
Total formats: 1, used formats: 1
Average record length: 32.13, total records: 8
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 352.00, compression ratio: 10.96
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 5%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index PK_WARE_GROUPS (0)
Root page: 328, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 11.25, total dup: 0, max dup: 0
Average key length: 10.13, compression ratio: 0.89
Average prefix length: 1.75, average data length: 7.25
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index WARE_GROUPS_NAME_UNQ (1)
Root page: 329, depth: 1, leaf buckets: 1, nodes: 8
Average node length: 19.88, total dup: 0, max dup: 0
Average key length: 18.13, compression ratio: 0.89
Average prefix length: 0.25, average data length: 15.88
Clustering factor: 1, ratio: 0.13
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQD_1000_1200 (260)
Primary pointer page: 298, Index root page: 307
Total formats: 1, used formats: 1
Average record length: 56.84, total records: 6579
Average version length: 72.23, total versions: 1398, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.39
Pointer pages: 2, data page slots: 2392
Data pages: 464, average fill: 18%
Primary pages: 463, secondary pages: 1, swept pages: 365
Empty pages: 210, full pages: 47
Fill distribution:
0 - 19% = 329
20 - 39% = 59
40 - 59% = 22
60 - 79% = 49
80 - 99% = 5

Index XQD_1000_1200_WARE_SOP_ROP_SND (0)
Root page: 1583, depth: 2, leaf buckets: 18, nodes: 6579
Average node length: 7.70, total dup: 5658, max dup: 14
Average key length: 4.71, compression ratio: 7.85
Average prefix length: 34.43, average data length: 2.57
Clustering factor: 1103, ratio: 0.17
Fill distribution:
0 - 19% = 2
20 - 39% = 9
40 - 59% = 5
60 - 79% = 2
80 - 99% = 0

XQD_1000_3300 (262)
Primary pointer page: 782, Index root page: 783
Total formats: 1, used formats: 1
Average record length: 71.84, total records: 1168652
Average version length: 71.84, total versions: 5506, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.89
Pointer pages: 12, data page slots: 18192
Data pages: 18184, average fill: 71%
Primary pages: 18184, secondary pages: 0, swept pages: 13755
Empty pages: 60, full pages: 11401
Fill distribution:
0 - 19% = 178
20 - 39% = 312
40 - 59% = 1667
60 - 79% = 15916
80 - 99% = 111

Index XQD_1000_3300_DOC (1)
Root page: 311766, depth: 3, leaf buckets: 1349, nodes: 1168652
Average node length: 5.13, total dup: 1138541, max dup: 122
Average key length: 2.19, compression ratio: 4.11
Average prefix length: 8.84, average data length: 0.16
Clustering factor: 133925, ratio: 0.11
Fill distribution:
0 - 19% = 17
20 - 39% = 85
40 - 59% = 1002
60 - 79% = 63
80 - 99% = 182

Index XQD_1000_3300_WARE_SOP_ROP_SND (0)
Root page: 226729, depth: 3, leaf buckets: 1729, nodes: 1168652
Average node length: 6.25, total dup: 1021035, max dup: 25
Average key length: 3.31, compression ratio: 11.16
Average prefix length: 35.81, average data length: 1.19
Clustering factor: 225436, ratio: 0.19
Fill distribution:
0 - 19% = 18
20 - 39% = 196
40 - 59% = 1281
60 - 79% = 161
80 - 99% = 73

XQD_1200_2000 (261)
Primary pointer page: 777, Index root page: 778
Total formats: 1, used formats: 1
Average record length: 30.96, total records: 111902
Average version length: 72.10, total versions: 4084, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 4.39
Pointer pages: 3, data page slots: 4632
Data pages: 4352, average fill: 18%
Primary pages: 4350, secondary pages: 2, swept pages: 4069
Empty pages: 657, full pages: 329
Fill distribution:
0 - 19% = 3229
20 - 39% = 529
40 - 59% = 162
60 - 79% = 348
80 - 99% = 84

Index XQD_1200_2000_WARE_SOP_ROP_SND (0)
Root page: 1052, depth: 2, leaf buckets: 94, nodes: 43630
Average node length: 6.63, total dup: 37915, max dup: 48
Average key length: 3.63, compression ratio: 10.19
Average prefix length: 35.50, average data length: 1.50
Clustering factor: 5072, ratio: 0.12
Fill distribution:
0 - 19% = 1
20 - 39% = 56
40 - 59% = 26
60 - 79% = 9
80 - 99% = 2

XQD_2000_3300 (263)
Primary pointer page: 786, Index root page: 787
Total formats: 1, used formats: 1
Average record length: 52.04, total records: 2161523
Average version length: 71.75, total versions: 38495, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.61
Pointer pages: 18, data page slots: 28792
Data pages: 28792, average fill: 65%
Primary pages: 28792, secondary pages: 0, swept pages: 17078
Empty pages: 186, full pages: 18883
Fill distribution:
0 - 19% = 586
20 - 39% = 3152
40 - 59% = 4123
60 - 79% = 18196
80 - 99% = 2735

Index XQD_2000_3300_WARE_SOP_ROP_SND (0)
Root page: 197044, depth: 3, leaf buckets: 2454, nodes: 1515970
Average node length: 5.65, total dup: 1421689, max dup: 49
Average key length: 2.68, compression ratio: 13.80
Average prefix length: 36.38, average data length: 0.62
Clustering factor: 207270, ratio: 0.14
Fill distribution:
0 - 19% = 18
20 - 39% = 1116
40 - 59% = 984
60 - 79% = 224
80 - 99% = 112

XQD_2100_3300 (264)
Primary pointer page: 789, Index root page: 790
Total formats: 1, used formats: 1
Average record length: 9.01, total records: 3919423
Average version length: 70.54, total versions: 699, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 15.09
Pointer pages: 16, data page slots: 25264
Data pages: 25264, average fill: 50%
Primary pages: 25264, secondary pages: 0, swept pages: 8928
Empty pages: 20, full pages: 23518
Fill distribution:
0 - 19% = 407
20 - 39% = 8286
40 - 59% = 6464
60 - 79% = 10092
80 - 99% = 15

Index XQD_2100_3300_WARE_SOP_ROP_SND (0)
Root page: 1684, depth: 2, leaf buckets: 9, nodes: 1723
Average node length: 11.66, total dup: 1189, max dup: 18
Average key length: 8.66, compression ratio: 4.27
Average prefix length: 30.65, average data length: 6.35
Clustering factor: 445, ratio: 0.26
Fill distribution:
0 - 19% = 1
20 - 39% = 7
40 - 59% = 1
60 - 79% = 0
80 - 99% = 0

XQD_3300_3400 (265)
Primary pointer page: 801, Index root page: 802
Total formats: 1, used formats: 1
Average record length: 63.65, total records: 3153477
Average version length: 71.07, total versions: 14875, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 2.14
Pointer pages: 26, data page slots: 41808
Data pages: 41808, average fill: 75%
Primary pages: 41808, secondary pages: 0, swept pages: 32085
Empty pages: 23, full pages: 35742
Fill distribution:
0 - 19% = 62
20 - 39% = 224
40 - 59% = 1106
60 - 79% = 38422
80 - 99% = 1994

Index XQD_3300_3400_WARE_SOP_ROP_SND (0)
Root page: 37222, depth: 3, leaf buckets: 5751, nodes: 2769680
Average node length: 6.89, total dup: 2241738, max dup: 15
Average key length: 3.91, compression ratio: 9.46
Average prefix length: 35.28, average data length: 1.72
Clustering factor: 553064, ratio: 0.20
Fill distribution:
0 - 19% = 9
20 - 39% = 3074
40 - 59% = 2308
60 - 79% = 213
80 - 99% = 147

XQS_1000_1200 (266)
Primary pointer page: 805, Index root page: 806
Total formats: 1, used formats: 1
Average record length: 83.67, total records: 4676067
Average version length: 84.14, total versions: 2586, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 45, data page slots: 71960
Data pages: 71960, average fill: 80%
Primary pages: 71960, secondary pages: 0, swept pages: 28981
Empty pages: 11, full pages: 70891
Fill distribution:
0 - 19% = 16
20 - 39% = 11
40 - 59% = 58
60 - 79% = 21933
80 - 99% = 49942

Index XQS_1000_1200_DOC_ID (0)
Root page: 55157, depth: 3, leaf buckets: 4772, nodes: 4676067
Average node length: 5.15, total dup: 4569685, max dup: 126
Average key length: 2.17, compression ratio: 4.15
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 758405, ratio: 0.16
Fill distribution:
0 - 19% = 18
20 - 39% = 62
40 - 59% = 2130
60 - 79% = 2028
80 - 99% = 534

Index XQS_1000_1200_RCV_ID (2)
Root page: 83992, depth: 3, leaf buckets: 5553, nodes: 4676067
Average node length: 5.70, total dup: 4184186, max dup: 49
Average key length: 2.71, compression ratio: 3.32
Average prefix length: 8.39, average data length: 0.61
Clustering factor: 277675, ratio: 0.06
Fill distribution:
0 - 19% = 74
20 - 39% = 254
40 - 59% = 3642
60 - 79% = 224
80 - 99% = 1359

Index XQS_1000_1200_SND_ID (1)
Root page: 48960, depth: 3, leaf buckets: 5315, nodes: 4676067
Average node length: 5.81, total dup: 4091466, max dup: 27
Average key length: 2.82, compression ratio: 3.19
Average prefix length: 8.30, average data length: 0.70
Clustering factor: 814489, ratio: 0.17
Fill distribution:
0 - 19% = 33
20 - 39% = 81
40 - 59% = 2325
60 - 79% = 2097
80 - 99% = 779

XQS_1000_3300 (268)
Primary pointer page: 815, Index root page: 816
Total formats: 1, used formats: 1
Average record length: 82.77, total records: 2364256
Average version length: 83.07, total versions: 14791, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.64
Pointer pages: 23, data page slots: 37256
Data pages: 37256, average fill: 78%
Primary pages: 37256, secondary pages: 0, swept pages: 27544
Empty pages: 25, full pages: 34296
Fill distribution:
0 - 19% = 52
20 - 39% = 109
40 - 59% = 503
60 - 79% = 17605
80 - 99% = 18987

Index XQS_1000_3300_DOC_ID (0)
Root page: 76716, depth: 3, leaf buckets: 2546, nodes: 2364256
Average node length: 5.15, total dup: 2309019, max dup: 227
Average key length: 2.18, compression ratio: 4.13
Average prefix length: 8.85, average data length: 0.15
Clustering factor: 378555, ratio: 0.16
Fill distribution:
0 - 19% = 2
20 - 39% = 45
40 - 59% = 1519
60 - 79% = 734
80 - 99% = 246

Index XQS_1000_3300_RCV_ID (2)
Root page: 110552, depth: 3, leaf buckets: 4198, nodes: 2364256
Average node length: 6.23, total dup: 1940463, max dup: 14
Average key length: 3.25, compression ratio: 2.77
Average prefix length: 7.92, average data length: 1.08
Clustering factor: 258708, ratio: 0.11
Fill distribution:
0 - 19% = 118
20 - 39% = 1887
40 - 59% = 1572
60 - 79% = 439
80 - 99% = 182

Index XQS_1000_3300_SND_ID (1)
Root page: 66178, depth: 3, leaf buckets: 2896, nodes: 2364256
Average node length: 5.81, total dup: 2068806, max dup: 37
Average key length: 2.84, compression ratio: 3.17
Average prefix length: 8.29, average data length: 0.71
Clustering factor: 445990, ratio: 0.19
Fill distribution:
0 - 19% = 21
20 - 39% = 32
40 - 59% = 1791
60 - 79% = 797
80 - 99% = 255

XQS_1200_2000 (267)
Primary pointer page: 810, Index root page: 811
Total formats: 1, used formats: 1
Average record length: 83.56, total records: 4937317
Average version length: 85.57, total versions: 16777, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 48, data page slots: 77424
Data pages: 77408, average fill: 79%
Primary pages: 77408, secondary pages: 0, swept pages: 24293
Empty pages: 91, full pages: 71961
Fill distribution:
0 - 19% = 225
20 - 39% = 479
40 - 59% = 1617
60 - 79% = 19907
80 - 99% = 55180

Index XQS_1200_2000_DOC_ID (0)
Root page: 58219, depth: 3, leaf buckets: 5303, nodes: 4937317
Average node length: 5.04, total dup: 4908038, max dup: 708
Average key length: 2.05, compression ratio: 4.38
Average prefix length: 8.95, average data length: 0.05
Clustering factor: 754651, ratio: 0.15
Fill distribution:
0 - 19% = 6
20 - 39% = 317
40 - 59% = 3027
60 - 79% = 1460
80 - 99% = 493

Index XQS_1200_2000_RCV_ID (2)
Root page: 84200, depth: 3, leaf buckets: 6232, nodes: 4937317
Average node length: 5.54, total dup: 4540123, max dup: 49
Average key length: 2.55, compression ratio: 3.53
Average prefix length: 8.53, average data length: 0.47
Clustering factor: 314280, ratio: 0.06
Fill distribution:
0 - 19% = 69
20 - 39% = 1780
40 - 59% = 2652
60 - 79% = 550
80 - 99% = 1181

Index XQS_1200_2000_SND_ID (1)
Root page: 50796, depth: 3, leaf buckets: 5959, nodes: 4937317
Average node length: 5.69, total dup: 4426842, max dup: 74
Average key length: 2.70, compression ratio: 3.33
Average prefix length: 8.40, average data length: 0.60
Clustering factor: 836156, ratio: 0.17
Fill distribution:
0 - 19% = 6
20 - 39% = 286
40 - 59% = 3451
60 - 79% = 1649
80 - 99% = 567

XQS_2000_3300 (269)
Primary pointer page: 821, Index root page: 822
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_DOC_ID (0)
Root page: 823, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_RCV_ID (2)
Root page: 825, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index XQS_2000_3300_SND_ID (1)
Root page: 824, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

XQS_2100_3300 (270)
Primary pointer page: 826, Index root page: 827
Total formats: 1, used formats: 1
Average record length: 83.34, total records: 3455885
Average version length: 83.39, total versions: 13844, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.63
Pointer pages: 34, data page slots: 54552
Data pages: 54552, average fill: 78%
Primary pages: 54552, secondary pages: 0, swept pages: 40340
Empty pages: 17, full pages: 50091
Fill distribution:
0 - 19% = 47
20 - 39% = 113
40 - 59% = 621
60 - 79% = 25458
80 - 99% = 28313

Index XQS_2100_3300_DOC_ID (0)
Root page: 92352, depth: 3, leaf buckets: 3734, nodes: 3455885
Average node length: 5.03, total dup: 3438560, max dup: 1188
Average key length: 2.05, compression ratio: 4.40
Average prefix length: 8.96, average data length: 0.04
Clustering factor: 754345, ratio: 0.22
Fill distribution:
0 - 19% = 13
20 - 39% = 345
40 - 59% = 2030
60 - 79% = 912
80 - 99% = 434

Index XQS_2100_3300_RCV_ID (2)
Root page: 110525, depth: 3, leaf buckets: 6336, nodes: 3455885
Average node length: 6.25, total dup: 2829103, max dup: 14
Average key length: 3.27, compression ratio: 2.75
Average prefix length: 7.91, average data length: 1.09
Clustering factor: 440171, ratio: 0.13
Fill distribution:
0 - 19% = 228
20 - 39% = 3025
40 - 59% = 2221
60 - 79% = 579
80 - 99% = 283

Index XQS_2100_3300_SND_ID (1)
Root page: 77842, depth: 3, leaf buckets: 4113, nodes: 3455885
Average node length: 5.59, total dup: 3150092, max dup: 83
Average key length: 2.61, compression ratio: 3.44
Average prefix length: 8.47, average data length: 0.53
Clustering factor: 793115, ratio: 0.23
Fill distribution:
0 - 19% = 17
20 - 39% = 377
40 - 59% = 2077
60 - 79% = 1150
80 - 99% = 492

XQS_3300_3400 (271)
Primary pointer page: 831, Index root page: 832
Total formats: 1, used formats: 1
Average record length: 69.12, total records: 690301
Average version length: 69.39, total versions: 3065, max versions: 1
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 136.00, compression ratio: 1.97
Pointer pages: 6, data page slots: 9512
Data pages: 9512, average fill: 77%
Primary pages: 9512, secondary pages: 0, swept pages: 6981
Empty pages: 1, full pages: 9134
Fill distribution:
0 - 19% = 10
20 - 39% = 24
40 - 59% = 65
60 - 79% = 9336
80 - 99% = 77

Index XQS_3300_3400_DOC_ID (0)
Root page: 208484, depth: 3, leaf buckets: 812, nodes: 690301
Average node length: 5.31, total dup: 651678, max dup: 119
Average key length: 2.43, compression ratio: 3.71
Average prefix length: 8.63, average data length: 0.37
Clustering factor: 57242, ratio: 0.08
Fill distribution:
0 - 19% = 2
20 - 39% = 158
40 - 59% = 340
60 - 79% = 235
80 - 99% = 77

Index XQS_3300_3400_SND_ID (1)
Root page: 163039, depth: 3, leaf buckets: 922, nodes: 690301
Average node length: 5.93, total dup: 590666, max dup: 14
Average key length: 3.04, compression ratio: 2.96
Average prefix length: 8.10, average data length: 0.90
Clustering factor: 62873, ratio: 0.09
Fill distribution:
0 - 19% = 4
20 - 39% = 187
40 - 59% = 390
60 - 79% = 247
80 - 99% = 94

ZDOC_DATA (230)
Primary pointer page: 674, Index root page: 675
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZDOC_LIST (229)
Primary pointer page: 672, Index root page: 673
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZINVNT_TURNOVER_LOG (231)
Primary pointer page: 676, Index root page: 677
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPDISTR (234)
Primary pointer page: 682, Index root page: 683
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPDISTR_ID (0)
Root page: 692, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZPSTORNED (235)
Primary pointer page: 684, Index root page: 685
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZPSTORNED_ID (0)
Root page: 693, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQDISTR (232)
Primary pointer page: 678, Index root page: 679
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_ID (0)
Root page: 686, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQDISTR_WARE_SNDOP_RCVOP (1)
Root page: 687, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZQSTORNED (233)
Primary pointer page: 680, Index root page: 681
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_DOC_ID (1)
Root page: 689, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_ID (0)
Root page: 688, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_RCV_ID (3)
Root page: 691, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index ZQSTORNED_SND_ID (2)
Root page: 690, depth: 1, leaf buckets: 1, nodes: 0
Average node length: 0.00, total dup: 0, max dup: 0
Average key length: 0.00, compression ratio: 0.00
Average prefix length: 0.00, average data length: 0.00
Clustering factor: 0, ratio: 0.00
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_DEP_DOCS (228)
Primary pointer page: 622, Index root page: 623
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

ZTMP_SHOPPING_CART (227)
Primary pointer page: 620, Index root page: 621
Total formats: 1, used formats: 0
Average record length: 0.00, total records: 0
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 0.00, compression ratio: 0.00
Pointer pages: 1, data page slots: 0
Data pages: 0, average fill: 0%
Primary pages: 0, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 0
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Z_USED_VIEWS (146)
Primary pointer page: 271, Index root page: 272
Total formats: 1, used formats: 1
Average record length: 29.38, total records: 29
Average version length: 0.00, total versions: 0, max versions: 0
Average fragment length: 0.00, total fragments: 0, max fragments: 0
Average unpacked length: 99.00, compression ratio: 3.37
Pointer pages: 1, data page slots: 1
Data pages: 1, average fill: 16%
Primary pages: 1, secondary pages: 0, swept pages: 0
Empty pages: 0, full pages: 0
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Index Z_USED_VIEWS_UNQ (0)
Root page: 284, depth: 1, leaf buckets: 1, nodes: 29
Average node length: 15.17, total dup: 0, max dup: 0
Average key length: 14.14, compression ratio: 1.44
Average prefix length: 9.17, average data length: 11.17
Clustering factor: 1, ratio: 0.03
Fill distribution:
0 - 19% = 1
20 - 39% = 0
40 - 59% = 0
60 - 79% = 0
80 - 99% = 0

Done for 83650 ms, from 11:55:50.42 to 11:57:14.07.

Analyzing DB stat log: obtaining values of total records and versions

TABLE_NAME TOTAL_RECS TOTAL_VERS VERS_PERCENT
AGENTS 50 0 0.0000
BUSINESS_OPS 19 0 0.0000
DOC_DATA 2156606 2615 0.1212
DOC_LIST 671418 241 0.0358
DOC_STATES 4 0 0.0000
FB_ERRORS 758 0 0.0000
INVNT_SALDO 400 0 0.0000
INVNT_TURNOVER_LOG 6514 2742 42.0939
MONEY_SALDO 49 0 0.0000
MONEY_TURNOVER_LOG 38 0 0.0000
OPTYPES 9 0 0.0000
PDISTR 812568 1083 0.1332
PERF_ESTIMATED 271624 0 0.0000
PERF_LOG 11443787 0 0.0000
PSTORNED 429949 999 0.2323
RULES_FOR_PDISTR 4 0 0.0000
RULES_FOR_QDISTR 7 0 0.0000
SEMAPHORES 4 0 0.0000
SETTINGS 114 0 0.0000
TRACE_STAT 2378 0 0.0000
WARES 400 0 0.0000
WARE_GROUPS 8 0 0.0000
XQD_1000_1200 6579 1398 21.2494
XQD_1000_3300 1168652 5506 0.4711
XQD_1200_2000 111902 4084 3.6496
XQD_2000_3300 2161523 38495 1.7809
XQD_2100_3300 3919423 699 0.0178
XQD_3300_3400 3153477 14875 0.4717
XQS_1000_1200 4676067 2586 0.0553
XQS_1000_3300 2364256 14791 0.6256
XQS_1200_2000 4937317 16777 0.3397
XQS_2100_3300 3455885 13844 0.4005
XQS_3300_3400 690301 3065 0.4440
Z_USED_VIEWS 29 0 0.0000
Done for 2640 ms, from 11:57:28.53 to 11:57:31.17.

Database validation

11:57:31.34 Validation started

11:57:31.36 Relation 140 (DOC_LIST)
11:57:31.36 process pointer page 0 of 6
11:57:31.46 process pointer page 1 of 6
11:57:31.57 process pointer page 2 of 6
11:57:31.70 process pointer page 3 of 6
11:57:31.81 process pointer page 4 of 6
11:57:31.92 process pointer page 5 of 6
11:57:31.95 Index 1 (PK_DOC_LIST)
11:57:32.23 Index 2 (DOC_LIST_ID_DESC)
11:57:32.45 Index 3 (FK_DOC_LIST_AGENTS)
11:57:32.54 Relation 140 (DOC_LIST) is ok

11:57:32.54 Relation 141 (DOC_DATA)
11:57:32.56 process pointer page 0 of 15
11:57:32.59 process pointer page 1 of 15
11:57:32.70 process pointer page 2 of 15
11:57:32.82 process pointer page 3 of 15
11:57:32.93 process pointer page 4 of 15
11:57:33.04 process pointer page 5 of 15
11:57:33.15 process pointer page 6 of 15
11:57:33.27 process pointer page 7 of 15
11:57:33.38 process pointer page 8 of 15
11:57:33.49 process pointer page 9 of 15
11:57:33.60 process pointer page 10 of 15
11:57:33.71 process pointer page 11 of 15
11:57:33.84 process pointer page 12 of 15
11:57:33.95 process pointer page 13 of 15
11:57:34.05 process pointer page 14 of 15
11:57:34.10 Index 2 (DOC_DATA_DOC_WARE_UNQ)
11:57:35.21 Index 3 (DOC_DATA_ID_DESC)
11:57:35.99 Index 4 (FK_DOC_DATA_DOC_LIST)
11:57:36.68 Relation 141 (DOC_DATA) is ok

11:57:36.68 Relation 147 (INVNT_SALDO)
11:57:36.68 process pointer page 0 of 1
11:57:36.68 Index 1 (PK_INVNT_SALDO)
11:57:36.68 Relation 147 (INVNT_SALDO) is ok

11:57:36.68 Relation 150 (PDISTR)
11:57:36.68 process pointer page 0 of 4
11:57:36.77 process pointer page 1 of 4
11:57:36.86 process pointer page 2 of 4
11:57:36.97 process pointer page 3 of 4
11:57:36.97 Index 2 (PDISTR_SND_ID)
11:57:37.07 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC)
11:57:37.16 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC)
11:57:37.25 Index 5 (PDISTR_AGENT_ID)
11:57:37.33 Relation 150 (PDISTR) is ok

11:57:37.33 Relation 151 (PSTORNED)
11:57:37.33 process pointer page 0 of 4
11:57:37.44 process pointer page 1 of 4
11:57:37.55 process pointer page 2 of 4
11:57:37.66 process pointer page 3 of 4
11:57:37.67 Index 2 (PSTORNED_SND_ID)
11:57:37.81 Index 3 (PSTORNED_RCV_ID)
11:57:37.95 Relation 151 (PSTORNED) is ok

11:57:37.95 Relation 156 (SEMAPHORES)
11:57:37.95 process pointer page 0 of 1
11:57:37.95 Index 1 (PK_SEMAPHORES)
11:57:37.95 Index 2 (SEMAPHORES_TASK_UNQ)
11:57:37.95 Relation 156 (SEMAPHORES) is ok

11:57:37.95 Relation 157 (INVNT_TURNOVER_LOG)
11:57:37.95 process pointer page 0 of 2
11:57:37.97 process pointer page 1 of 2
11:57:37.97 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID)
11:57:37.99 Relation 157 (INVNT_TURNOVER_LOG) is ok

11:57:37.99 Relation 160 (PERF_ESTIMATED)
11:57:37.99 process pointer page 0 of 2
11:57:38.09 process pointer page 1 of 2
11:57:38.16 Index 1 (PERF_EST_MINUTE_SINCE_START)
11:57:38.24 Relation 160 (PERF_ESTIMATED) is ok

11:57:38.24 Relation 161 (PERF_ISQL_STAT)
11:57:38.24 process pointer page 0 of 1
11:57:38.24 Index 1 (PERF_ISQL_STAT_TRN)
11:57:38.24 Relation 161 (PERF_ISQL_STAT) is ok

11:57:38.24 Relation 162 (TRACE_STAT)
11:57:38.24 process pointer page 0 of 1
11:57:38.24 Relation 162 (TRACE_STAT) is ok

11:57:38.24 Relation 163 (PERF_LOG)
11:57:38.24 process pointer page 0 of 167
11:57:38.33 process pointer page 1 of 167
11:57:38.42 process pointer page 2 of 167
11:57:38.52 process pointer page 3 of 167
11:57:38.59 process pointer page 4 of 167
11:57:38.69 process pointer page 5 of 167
11:57:38.78 process pointer page 6 of 167
11:57:38.87 process pointer page 7 of 167
11:57:38.97 process pointer page 8 of 167
11:57:39.06 process pointer page 9 of 167
11:57:39.16 process pointer page 10 of 167
11:57:39.25 process pointer page 11 of 167
11:57:39.33 process pointer page 12 of 167
11:57:39.42 process pointer page 13 of 167
11:57:39.51 process pointer page 14 of 167
11:57:39.61 process pointer page 15 of 167
11:57:39.70 process pointer page 16 of 167
11:57:39.80 process pointer page 17 of 167
11:57:39.89 process pointer page 18 of 167
11:57:39.98 process pointer page 19 of 167
11:57:40.06 process pointer page 20 of 167
11:57:40.15 process pointer page 21 of 167
11:57:40.25 process pointer page 22 of 167
11:57:40.34 process pointer page 23 of 167
11:57:40.43 process pointer page 24 of 167
11:57:40.51 process pointer page 25 of 167
11:57:40.61 process pointer page 26 of 167
11:57:40.67 process pointer page 27 of 167
11:57:40.72 process pointer page 28 of 167
11:57:40.81 process pointer page 29 of 167
11:57:40.90 process pointer page 30 of 167
11:57:41.00 process pointer page 31 of 167
11:57:41.09 process pointer page 32 of 167
11:57:41.17 process pointer page 33 of 167
11:57:41.26 process pointer page 34 of 167
11:57:41.36 process pointer page 35 of 167
11:57:41.45 process pointer page 36 of 167
11:57:41.54 process pointer page 37 of 167
11:57:41.64 process pointer page 38 of 167
11:57:41.71 process pointer page 39 of 167
11:57:41.81 process pointer page 40 of 167
11:57:41.90 process pointer page 41 of 167
11:57:41.99 process pointer page 42 of 167
11:57:42.09 process pointer page 43 of 167
11:57:42.17 process pointer page 44 of 167
11:57:42.26 process pointer page 45 of 167
11:57:42.35 process pointer page 46 of 167
11:57:42.45 process pointer page 47 of 167
11:57:42.54 process pointer page 48 of 167
11:57:42.63 process pointer page 49 of 167
11:57:42.71 process pointer page 50 of 167
11:57:42.81 process pointer page 51 of 167
11:57:42.90 process pointer page 52 of 167
11:57:42.99 process pointer page 53 of 167
11:57:43.07 process pointer page 54 of 167
11:57:43.16 process pointer page 55 of 167
11:57:43.26 process pointer page 56 of 167
11:57:43.35 process pointer page 57 of 167
11:57:43.45 process pointer page 58 of 167
11:57:43.52 process pointer page 59 of 167
11:57:43.62 process pointer page 60 of 167
11:57:43.71 process pointer page 61 of 167
11:57:43.80 process pointer page 62 of 167
11:57:43.88 process pointer page 63 of 167
11:57:43.98 process pointer page 64 of 167
11:57:44.07 process pointer page 65 of 167
11:57:44.16 process pointer page 66 of 167
11:57:44.24 process pointer page 67 of 167
11:57:44.33 process pointer page 68 of 167
11:57:44.43 process pointer page 69 of 167
11:57:44.52 process pointer page 70 of 167
11:57:44.60 process pointer page 71 of 167
11:57:44.69 process pointer page 72 of 167
11:57:44.79 process pointer page 73 of 167
11:57:44.87 process pointer page 74 of 167
11:57:44.96 process pointer page 75 of 167
11:57:45.05 process pointer page 76 of 167
11:57:45.15 process pointer page 77 of 167
11:57:45.24 process pointer page 78 of 167
11:57:45.32 process pointer page 79 of 167
11:57:45.41 process pointer page 80 of 167
11:57:45.50 process pointer page 81 of 167
11:57:45.60 process pointer page 82 of 167
11:57:45.68 process pointer page 83 of 167
11:57:45.77 process pointer page 84 of 167
11:57:45.86 process pointer page 85 of 167
11:57:45.96 process pointer page 86 of 167
11:57:46.05 process pointer page 87 of 167
11:57:46.13 process pointer page 88 of 167
11:57:46.22 process pointer page 89 of 167
11:57:46.32 process pointer page 90 of 167
11:57:46.41 process pointer page 91 of 167
11:57:46.49 process pointer page 92 of 167
11:57:46.58 process pointer page 93 of 167
11:57:46.67 process pointer page 94 of 167
11:57:46.75 process pointer page 95 of 167
11:57:46.85 process pointer page 96 of 167
11:57:46.94 process pointer page 97 of 167
11:57:47.03 process pointer page 98 of 167
11:57:47.11 process pointer page 99 of 167
11:57:47.21 process pointer page 100 of 167
11:57:47.30 process pointer page 101 of 167
11:57:47.39 process pointer page 102 of 167
11:57:47.47 process pointer page 103 of 167
11:57:47.56 process pointer page 104 of 167
11:57:47.66 process pointer page 105 of 167
11:57:47.75 process pointer page 106 of 167
11:57:47.83 process pointer page 107 of 167
11:57:47.92 process pointer page 108 of 167
11:57:48.02 process pointer page 109 of 167
11:57:48.11 process pointer page 110 of 167
11:57:48.19 process pointer page 111 of 167
11:57:48.28 process pointer page 112 of 167
11:57:48.38 process pointer page 113 of 167
11:57:48.47 process pointer page 114 of 167
11:57:48.56 process pointer page 115 of 167
11:57:48.64 process pointer page 116 of 167
11:57:48.73 process pointer page 117 of 167
11:57:48.83 process pointer page 118 of 167
11:57:48.92 process pointer page 119 of 167
11:57:49.00 process pointer page 120 of 167
11:57:49.09 process pointer page 121 of 167
11:57:49.19 process pointer page 122 of 167
11:57:49.28 process pointer page 123 of 167
11:57:49.37 process pointer page 124 of 167
11:57:49.42 process pointer page 125 of 167
11:57:49.48 process pointer page 126 of 167
11:57:49.56 process pointer page 127 of 167
11:57:49.65 process pointer page 128 of 167
11:57:49.75 process pointer page 129 of 167
11:57:49.84 process pointer page 130 of 167
11:57:49.92 process pointer page 131 of 167
11:57:50.01 process pointer page 132 of 167
11:57:50.11 process pointer page 133 of 167
11:57:50.20 process pointer page 134 of 167
11:57:50.29 process pointer page 135 of 167
11:57:50.37 process pointer page 136 of 167
11:57:50.47 process pointer page 137 of 167
11:57:50.56 process pointer page 138 of 167
11:57:50.65 process pointer page 139 of 167
11:57:50.73 process pointer page 140 of 167
11:57:50.82 process pointer page 141 of 167
11:57:50.92 process pointer page 142 of 167
11:57:51.01 process pointer page 143 of 167
11:57:51.11 process pointer page 144 of 167
11:57:51.18 process pointer page 145 of 167
11:57:51.28 process pointer page 146 of 167
11:57:51.37 process pointer page 147 of 167
11:57:51.46 process pointer page 148 of 167
11:57:51.56 process pointer page 149 of 167
11:57:51.65 process pointer page 150 of 167
11:57:51.73 process pointer page 151 of 167
11:57:51.82 process pointer page 152 of 167
11:57:51.92 process pointer page 153 of 167
11:57:52.01 process pointer page 154 of 167
11:57:52.10 process pointer page 155 of 167
11:57:52.18 process pointer page 156 of 167
11:57:52.28 process pointer page 157 of 167
11:57:52.37 process pointer page 158 of 167
11:57:52.46 process pointer page 159 of 167
11:57:52.56 process pointer page 160 of 167
11:57:52.65 process pointer page 161 of 167
11:57:52.73 process pointer page 162 of 167
11:57:52.82 process pointer page 163 of 167
11:57:52.91 process pointer page 164 of 167
11:57:53.01 process pointer page 165 of 167
11:57:53.10 process pointer page 166 of 167
11:57:53.13 Index 1 (PERF_LOG_DTS_BEG_DESC)
11:57:57.80 Index 2 (PERF_LOG_UNIT)
11:58:04.38 Index 3 (PERF_LOG_TRN_DESC)
11:58:07.69 Index 4 (PERF_LOG_GDSCODE)
11:58:10.37 Relation 163 (PERF_LOG) is ok

11:58:10.37 Relation 167 (V_STOPTEST)
11:58:10.37 Relation 167 (V_STOPTEST) is ok

11:58:10.37 Relation 184 (V_QDISTR_SOURCE)
11:58:10.37 Relation 184 (V_QDISTR_SOURCE) is ok

11:58:10.37 Relation 185 (V_QSTORNED_SOURCE)
11:58:10.37 Relation 185 (V_QSTORNED_SOURCE) is ok

11:58:10.37 Relation 260 (XQD_1000_1200)
11:58:10.39 process pointer page 0 of 2
11:58:10.39 process pointer page 1 of 2
11:58:10.40 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND)
11:58:10.42 Relation 260 (XQD_1000_1200) is ok

11:58:10.42 Relation 261 (XQD_1200_2000)
11:58:10.42 process pointer page 0 of 3
11:58:10.46 process pointer page 1 of 3
11:58:10.53 process pointer page 2 of 3
11:58:10.57 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND)
11:58:10.59 Relation 261 (XQD_1200_2000) is ok

11:58:10.59 Relation 262 (XQD_1000_3300)
11:58:10.59 process pointer page 0 of 12
11:58:10.70 process pointer page 1 of 12
11:58:10.79 process pointer page 2 of 12
11:58:10.90 process pointer page 3 of 12
11:58:11.00 process pointer page 4 of 12
11:58:11.10 process pointer page 5 of 12
11:58:11.20 process pointer page 6 of 12
11:58:11.31 process pointer page 7 of 12
11:58:11.40 process pointer page 8 of 12
11:58:11.51 process pointer page 9 of 12
11:58:11.62 process pointer page 10 of 12
11:58:11.71 process pointer page 11 of 12
11:58:11.73 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND)
11:58:12.18 Index 2 (XQD_1000_3300_DOC)
11:58:12.52 Relation 262 (XQD_1000_3300) is ok

11:58:12.52 Relation 263 (XQD_2000_3300)
11:58:12.52 process pointer page 0 of 18
11:58:12.57 process pointer page 1 of 18
11:58:12.65 process pointer page 2 of 18
11:58:12.76 process pointer page 3 of 18
11:58:12.85 process pointer page 4 of 18
11:58:12.96 process pointer page 5 of 18
11:58:13.05 process pointer page 6 of 18
11:58:13.16 process pointer page 7 of 18
11:58:13.26 process pointer page 8 of 18
11:58:13.35 process pointer page 9 of 18
11:58:13.46 process pointer page 10 of 18
11:58:13.55 process pointer page 11 of 18
11:58:13.65 process pointer page 12 of 18
11:58:13.74 process pointer page 13 of 18
11:58:13.85 process pointer page 14 of 18
11:58:13.94 process pointer page 15 of 18
11:58:14.04 process pointer page 16 of 18
11:58:14.15 process pointer page 17 of 18
11:58:14.21 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND)
11:58:14.77 Relation 263 (XQD_2000_3300) is ok

11:58:14.77 Relation 264 (XQD_2100_3300)
11:58:14.77 process pointer page 0 of 16
11:58:14.83 process pointer page 1 of 16
11:58:14.91 process pointer page 2 of 16
11:58:14.97 process pointer page 3 of 16
11:58:15.04 process pointer page 4 of 16
11:58:15.10 process pointer page 5 of 16
11:58:15.18 process pointer page 6 of 16
11:58:15.24 process pointer page 7 of 16
11:58:15.30 process pointer page 8 of 16
11:58:15.36 process pointer page 9 of 16
11:58:15.44 process pointer page 10 of 16
11:58:15.50 process pointer page 11 of 16
11:58:15.57 process pointer page 12 of 16
11:58:15.63 process pointer page 13 of 16
11:58:15.69 process pointer page 14 of 16
11:58:15.75 process pointer page 15 of 16
11:58:15.78 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND)
11:58:15.78 Relation 264 (XQD_2100_3300) is ok

11:58:15.78 Relation 265 (XQD_3300_3400)
11:58:15.78 process pointer page 0 of 26
11:58:15.89 process pointer page 1 of 26
11:58:16.00 process pointer page 2 of 26
11:58:16.10 process pointer page 3 of 26
11:58:16.21 process pointer page 4 of 26
11:58:16.31 process pointer page 5 of 26
11:58:16.42 process pointer page 6 of 26
11:58:16.52 process pointer page 7 of 26
11:58:16.63 process pointer page 8 of 26
11:58:16.74 process pointer page 9 of 26
11:58:16.83 process pointer page 10 of 26
11:58:16.94 process pointer page 11 of 26
11:58:17.05 process pointer page 12 of 26
11:58:17.17 process pointer page 13 of 26
11:58:17.28 process pointer page 14 of 26
11:58:17.41 process pointer page 15 of 26
11:58:17.52 process pointer page 16 of 26
11:58:17.64 process pointer page 17 of 26
11:58:17.77 process pointer page 18 of 26
11:58:17.87 process pointer page 19 of 26
11:58:18.00 process pointer page 20 of 26
11:58:18.12 process pointer page 21 of 26
11:58:18.25 process pointer page 22 of 26
11:58:18.36 process pointer page 23 of 26
11:58:18.48 process pointer page 24 of 26
11:58:18.59 process pointer page 25 of 26
11:58:18.67 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND)
11:58:19.92 Relation 265 (XQD_3300_3400) is ok

11:58:19.92 Relation 266 (XQS_1000_1200)
11:58:19.93 process pointer page 0 of 45
11:58:20.04 process pointer page 1 of 45
11:58:20.17 process pointer page 2 of 45
11:58:20.28 process pointer page 3 of 45
11:58:20.40 process pointer page 4 of 45
11:58:20.53 process pointer page 5 of 45
11:58:20.65 process pointer page 6 of 45
11:58:20.76 process pointer page 7 of 45
11:58:20.89 process pointer page 8 of 45
11:58:21.01 process pointer page 9 of 45
11:58:21.14 process pointer page 10 of 45
11:58:21.24 process pointer page 11 of 45
11:58:21.37 process pointer page 12 of 45
11:58:21.49 process pointer page 13 of 45
11:58:21.60 process pointer page 14 of 45
11:58:21.73 process pointer page 15 of 45
11:58:21.85 process pointer page 16 of 45
11:58:21.96 process pointer page 17 of 45
11:58:22.09 process pointer page 18 of 45
11:58:22.20 process pointer page 19 of 45
11:58:22.32 process pointer page 20 of 45
11:58:22.45 process pointer page 21 of 45
11:58:22.65 process pointer page 22 of 45
11:58:23.10 process pointer page 23 of 45
11:58:23.54 process pointer page 24 of 45
11:58:23.96 process pointer page 25 of 45
11:58:24.38 process pointer page 26 of 45
11:58:24.83 process pointer page 27 of 45
11:58:25.27 process pointer page 28 of 45
11:58:25.69 process pointer page 29 of 45
11:58:26.08 process pointer page 30 of 45
11:58:26.53 process pointer page 31 of 45
11:58:26.97 process pointer page 32 of 45
11:58:27.34 process pointer page 33 of 45
11:58:27.66 process pointer page 34 of 45
11:58:28.00 process pointer page 35 of 45
11:58:28.33 process pointer page 36 of 45
11:58:28.67 process pointer page 37 of 45
11:58:29.01 process pointer page 38 of 45
11:58:29.36 process pointer page 39 of 45
11:58:29.72 process pointer page 40 of 45
11:58:30.06 process pointer page 41 of 45
11:58:30.40 process pointer page 42 of 45
11:58:30.74 process pointer page 43 of 45
11:58:31.12 process pointer page 44 of 45
11:58:31.15 Index 1 (XQS_1000_1200_DOC_ID)
11:58:33.66 Index 2 (XQS_1000_1200_SND_ID)
11:58:36.31 Index 3 (XQS_1000_1200_RCV_ID)
11:58:38.79 Relation 266 (XQS_1000_1200) is ok

11:58:38.79 Relation 267 (XQS_1200_2000)
11:58:38.79 process pointer page 0 of 48
11:58:39.25 process pointer page 1 of 48
11:58:39.68 process pointer page 2 of 48
11:58:40.10 process pointer page 3 of 48
11:58:40.54 process pointer page 4 of 48
11:58:40.96 process pointer page 5 of 48
11:58:41.37 process pointer page 6 of 48
11:58:41.81 process pointer page 7 of 48
11:58:42.26 process pointer page 8 of 48
11:58:42.68 process pointer page 9 of 48
11:58:43.12 process pointer page 10 of 48
11:58:43.55 process pointer page 11 of 48
11:58:43.99 process pointer page 12 of 48
11:58:44.46 process pointer page 13 of 48
11:58:44.88 process pointer page 14 of 48
11:58:45.32 process pointer page 15 of 48
11:58:45.78 process pointer page 16 of 48
11:58:46.27 process pointer page 17 of 48
11:58:46.69 process pointer page 18 of 48
11:58:47.11 process pointer page 19 of 48
11:58:47.56 process pointer page 20 of 48
11:58:48.05 process pointer page 21 of 48
11:58:48.54 process pointer page 22 of 48
11:58:49.01 process pointer page 23 of 48
11:58:49.50 process pointer page 24 of 48
11:58:49.98 process pointer page 25 of 48
11:58:50.46 process pointer page 26 of 48
11:58:50.95 process pointer page 27 of 48
11:58:51.43 process pointer page 28 of 48
11:58:51.90 process pointer page 29 of 48
11:58:52.38 process pointer page 30 of 48
11:58:52.85 process pointer page 31 of 48
11:58:53.32 process pointer page 32 of 48
11:58:53.80 process pointer page 33 of 48
11:58:54.27 process pointer page 34 of 48
11:58:54.72 process pointer page 35 of 48
11:58:55.17 process pointer page 36 of 48
11:58:55.63 process pointer page 37 of 48
11:58:56.05 process pointer page 38 of 48
11:58:56.49 process pointer page 39 of 48
11:58:56.91 process pointer page 40 of 48
11:58:57.36 process pointer page 41 of 48
11:58:57.81 process pointer page 42 of 48
11:58:58.25 process pointer page 43 of 48
11:58:58.68 process pointer page 44 of 48
11:58:59.11 process pointer page 45 of 48
11:58:59.56 process pointer page 46 of 48
11:59:00.00 process pointer page 47 of 48
11:59:00.15 Index 1 (XQS_1200_2000_DOC_ID)
11:59:03.02 Index 2 (XQS_1200_2000_SND_ID)
11:59:06.20 Index 3 (XQS_1200_2000_RCV_ID)
11:59:09.03 Relation 267 (XQS_1200_2000) is ok

11:59:09.03 Relation 268 (XQS_1000_3300)
11:59:09.03 process pointer page 0 of 23
11:59:09.54 process pointer page 1 of 23
11:59:10.06 process pointer page 2 of 23
11:59:10.56 process pointer page 3 of 23
11:59:11.06 process pointer page 4 of 23
11:59:11.57 process pointer page 5 of 23
11:59:12.09 process pointer page 6 of 23
11:59:12.58 process pointer page 7 of 23
11:59:13.08 process pointer page 8 of 23
11:59:13.58 process pointer page 9 of 23
11:59:14.08 process pointer page 10 of 23
11:59:14.60 process pointer page 11 of 23
11:59:15.10 process pointer page 12 of 23
11:59:15.60 process pointer page 13 of 23
11:59:16.08 process pointer page 14 of 23
11:59:16.59 process pointer page 15 of 23
11:59:17.08 process pointer page 16 of 23
11:59:17.56 process pointer page 17 of 23
11:59:18.06 process pointer page 18 of 23
11:59:18.53 process pointer page 19 of 23
11:59:18.98 process pointer page 20 of 23
11:59:19.45 process pointer page 21 of 23
11:59:19.90 process pointer page 22 of 23
11:59:20.23 Index 1 (XQS_1000_3300_DOC_ID)
11:59:21.73 Index 2 (XQS_1000_3300_SND_ID)
11:59:23.35 Index 3 (XQS_1000_3300_RCV_ID)
11:59:25.11 Relation 268 (XQS_1000_3300) is ok

11:59:25.11 Relation 269 (XQS_2000_3300)
11:59:25.13 process pointer page 0 of 1
11:59:25.13 Index 1 (XQS_2000_3300_DOC_ID)
11:59:25.13 Index 2 (XQS_2000_3300_SND_ID)
11:59:25.13 Index 3 (XQS_2000_3300_RCV_ID)
11:59:25.13 Relation 269 (XQS_2000_3300) is ok

11:59:25.13 Relation 270 (XQS_2100_3300)
11:59:25.13 process pointer page 0 of 34
11:59:25.63 process pointer page 1 of 34
11:59:26.13 process pointer page 2 of 34
11:59:26.64 process pointer page 3 of 34
11:59:27.15 process pointer page 4 of 34
11:59:27.65 process pointer page 5 of 34
11:59:28.15 process pointer page 6 of 34
11:59:28.65 process pointer page 7 of 34
11:59:29.15 process pointer page 8 of 34
11:59:29.67 process pointer page 9 of 34
11:59:30.17 process pointer page 10 of 34
11:59:30.66 process pointer page 11 of 34
11:59:31.16 process pointer page 12 of 34
11:59:31.66 process pointer page 13 of 34
11:59:32.15 process pointer page 14 of 34
11:59:32.65 process pointer page 15 of 34
11:59:33.15 process pointer page 16 of 34
11:59:33.68 process pointer page 17 of 34
11:59:34.14 process pointer page 18 of 34
11:59:34.61 process pointer page 19 of 34
11:59:35.10 process pointer page 20 of 34
11:59:35.56 process pointer page 21 of 34
11:59:36.02 process pointer page 22 of 34
11:59:36.48 process pointer page 23 of 34
11:59:36.95 process pointer page 24 of 34
11:59:37.42 process pointer page 25 of 34
11:59:37.86 process pointer page 26 of 34
11:59:38.31 process pointer page 27 of 34
11:59:38.75 process pointer page 28 of 34
11:59:39.18 process pointer page 29 of 34
11:59:39.60 process pointer page 30 of 34
11:59:40.02 process pointer page 31 of 34
11:59:40.45 process pointer page 32 of 34
11:59:40.85 process pointer page 33 of 34
11:59:40.99 Index 1 (XQS_2100_3300_DOC_ID)
11:59:43.14 Index 2 (XQS_2100_3300_SND_ID)
11:59:45.45 Index 3 (XQS_2100_3300_RCV_ID)
11:59:48.00 Relation 270 (XQS_2100_3300) is ok

11:59:48.00 Relation 271 (XQS_3300_3400)
11:59:48.00 process pointer page 0 of 6
11:59:48.50 process pointer page 1 of 6
11:59:48.98 process pointer page 2 of 6
11:59:49.46 process pointer page 3 of 6
11:59:49.96 process pointer page 4 of 6
11:59:50.45 process pointer page 5 of 6
11:59:50.82 Index 1 (XQS_3300_3400_DOC_ID)
11:59:51.21 Index 2 (XQS_3300_3400_SND_ID)
11:59:51.65 Relation 271 (XQS_3300_3400) is ok

11:59:51.66 Validation finished
Done for 140570 ms, from 11:57:31.20 to 11:59:51.77.

Differences between old and current firebird.log

11:59:53.91. Got:
STDOUT: ---------- E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG: 13 (number of rows in extracted log)
Obtained firebird.log info:
Result of DIR command for firebird.log AFTER test finish:
2017-03-29 11:59 478 oltp40_fb_log_when_test_finished.log

End of gathering firebird.log AFTER test finish.

Comparison of old and new firebird.log (get messages that appeared during test):

+++ Start of comparison +++
Comparing files E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
***** E:\TEMP\LOGS.OLTP40\oltp40_fb_log_when_test_started.log
***** E:\TEMP\LOGS.OLTP40\OLTP40_FB_LOG_WHEN_TEST_FINISHED.LOG
5:
6: WIN-2BE1UI8LGDL Wed Mar 29 11:57:31 2017
7: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
8: Validation started
9:
10:
11: WIN-2BE1UI8LGDL Wed Mar 29 11:59:51 2017
12: Database: D:\OLTP-EMUL\OLTP40-SMALL.FDB
13: Validation finished: 0 errors, 0 warnings, 0 fixed
14:
*****
+++ End of comparison +++

Final processing ISQL logs in e:\temp\logs.oltp40


Remove 401 logs of every ISQL session if there were no serious errors.

Remove logs of every ISQL session if there were no serious errors, pattern: e:\temp\logs.oltp40\oltp40_*.*:

ERRORS_CHECKING_RESULT
NO_SEVERE_ERRORS_FOUND
ISQL logs are removed because no severe errors occured during test.
2017-03-29 12:00:05.25 - end of report, text file: e:\temp\logs.oltp40\oltp40.report.txt, html: e:\temp\logs.oltp40\oltp40.report.html