| ACTION | AVG_TIMES_PER_MINUTE | AVG_ELAPSED_MS | SUCCESSFUL_TIMES_DONE | JOB_BEG | JOB_END | 
| *** OVERALL *** for 180 minutes: | 5248.09 | 7164 | 944656 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| customer order: creation | 400.95 | 1033 | 72171 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| customer order: refuse | 31.38 | 76 | 5648 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| order to supplier: creation | 101.64 | 7396 | 18296 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| order to supplier: removal | 2.41 | 78523 | 429 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| invoice (draft): creation | 103.11 | 11491 | 18559 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| invoice (draft): removal | 35.47 | 2440 | 6350 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| invoice accept: apply | 63.99 | 21866 | 11518 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| invoice accept: cancel | 16.21 | 4907 | 2917 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| customer reserve: creation | 3121.54 | 382 | 561877 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| customer reserve: removal | 831.69 | 142 | 148873 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| realization accept: apply | 183.81 | 337 | 33086 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| realization accept: cancel | 51.72 | 229 | 9257 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| payment from customer: creation | 134.43 | 306 | 24197 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| payment from customer: removal | 12.75 | 103 | 2282 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| payment to supplier: creation | 110.00 | 670 | 19800 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| payment to supplier: removal | 7.56 | 143 | 1353 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| service: total inventory turnovers | 21.34 | 1319 | 3842 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| service: total monetary turnovers | 23.27 | 56 | 4189 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| service: refresh index statistics | 0.07 | 4690 | 12 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
 
Done for 74960 ms, from  6:57:54.27 to  6:59:09.23.  
 
| ACTION | ITRV_NO | CNT_OK_PER_MINUTE | CNT_ALL | CNT_OK | CNT_ERR | ERR_PRC | ITRV_BEG | ITRV_END | 
| interval #   1, overall | 1 | 3564 | 71308 | 64147 | 7161 | 10.04 | 03:56:06 | 04:14:06 | 
| interval #   2, overall | 2 | 5073 | 97199 | 91315 | 5884 | 6.05 | 04:14:07 | 04:32:07 | 
| interval #   3, overall | 3 | 5438 | 102342 | 97885 | 4457 | 4.36 | 04:32:08 | 04:50:08 | 
| interval #   4, overall | 4 | 5582 | 106325 | 100472 | 5853 | 5.50 | 04:50:09 | 05:08:09 | 
| interval #   5, overall | 5 | 5487 | 104400 | 98764 | 5636 | 5.40 | 05:08:10 | 05:26:10 | 
| interval #   6, overall | 6 | 5670 | 109441 | 102058 | 7383 | 6.75 | 05:26:11 | 05:44:11 | 
| interval #   7, overall | 7 | 5740 | 108376 | 103314 | 5062 | 4.67 | 05:44:12 | 06:02:12 | 
| interval #   8, overall | 8 | 5288 | 100650 | 95176 | 5474 | 5.44 | 06:02:13 | 06:20:13 | 
| interval #   9, overall | 9 | 5269 | 100811 | 94833 | 5978 | 5.93 | 06:20:14 | 06:38:14 | 
| interval #  10, overall | 10 | 5372 | 99999 | 96692 | 3307 | 3.31 | 06:38:15 | 06:56:15 | 
 
Done for 135780 ms, from  6:59:52.98 to  7:02:08.76.  
 
| TEST_PHASE | MINUTE_SINCE_TEST_START | AVG_ESTIMATED | MIN_TO_AVG_RATIO | MAX_TO_AVG_RATIO | ROWS_AGGREGATED | DISTINCT_ATTACHMENTS | 
| WARM_TIME | 1 | 5892.13 | 0.7340 | 1.2233 | 2678 | 94 | 
| WARM_TIME | 2 | 4141.86 | 0.8702 | 1.1352 | 1976 | 78 | 
| WARM_TIME | 3 | 3376.52 | 0.9284 | 1.0739 | 1390 | 53 | 
| WARM_TIME | 4 | 2921.21 | 0.9311 | 1.0703 | 1261 | 51 | 
| WARM_TIME | 5 | 2664.20 | 0.9389 | 1.0544 | 993 | 43 | 
| WARM_TIME | 6 | 2439.15 | 0.9598 | 1.0398 | 831 | 36 | 
| WARM_TIME | 7 | 2299.77 | 0.9453 | 1.0453 | 859 | 42 | 
| WARM_TIME | 8 | 2213.55 | 0.9503 | 1.0506 | 928 | 43 | 
| WARM_TIME | 9 | 2203.95 | 0.9379 | 1.0505 | 1185 | 53 | 
| WARM_TIME | 10 | 2174.89 | 0.9581 | 1.0422 | 1182 | 52 | 
| TEST_TIME | 11 | 2134.96 | 0.9652 | 1.0458 | 957 | 54 | 
| TEST_TIME | 12 | 2173.77 | 0.9416 | 1.0643 | 1274 | 72 | 
| TEST_TIME | 13 | 2257.58 | 0.9460 | 1.0550 | 1467 | 82 | 
| TEST_TIME | 14 | 2362.65 | 0.9361 | 1.0572 | 1507 | 90 | 
| TEST_TIME | 15 | 2452.37 | 0.9506 | 1.0473 | 1548 | 91 | 
| TEST_TIME | 16 | 2517.56 | 0.9564 | 1.0469 | 1611 | 94 | 
| TEST_TIME | 17 | 2587.97 | 0.9585 | 1.0381 | 1552 | 94 | 
| TEST_TIME | 18 | 2619.97 | 0.9684 | 1.0356 | 1452 | 95 | 
| TEST_TIME | 19 | 2680.79 | 0.9588 | 1.0360 | 1297 | 98 | 
| TEST_TIME | 20 | 2717.60 | 0.9708 | 1.0339 | 1332 | 97 | 
| TEST_TIME | 21 | 2757.17 | 0.9706 | 1.0332 | 1436 | 95 | 
| TEST_TIME | 22 | 2800.95 | 0.9708 | 1.0249 | 1440 | 90 | 
| TEST_TIME | 23 | 2826.19 | 0.9716 | 1.0333 | 1362 | 93 | 
| TEST_TIME | 24 | 2859.76 | 0.9786 | 1.0251 | 1138 | 99 | 
| TEST_TIME | 25 | 2909.02 | 0.9675 | 1.0368 | 1189 | 100 | 
| TEST_TIME | 26 | 2982.37 | 0.9724 | 1.0306 | 2095 | 99 | 
| TEST_TIME | 27 | 3068.79 | 0.9645 | 1.0363 | 2106 | 98 | 
| TEST_TIME | 28 | 3148.58 | 0.9740 | 1.0260 | 1927 | 96 | 
| TEST_TIME | 29 | 3223.83 | 0.9675 | 1.0267 | 1927 | 99 | 
| TEST_TIME | 30 | 3281.89 | 0.9749 | 1.0236 | 1825 | 97 | 
| TEST_TIME | 31 | 3326.12 | 0.9774 | 1.0228 | 1545 | 97 | 
| TEST_TIME | 32 | 3384.31 | 0.9738 | 1.0231 | 1579 | 98 | 
| TEST_TIME | 33 | 3428.47 | 0.9794 | 1.0237 | 1662 | 96 | 
| TEST_TIME | 34 | 3480.45 | 0.9787 | 1.0213 | 1566 | 95 | 
| TEST_TIME | 35 | 3516.65 | 0.9819 | 1.0181 | 1542 | 97 | 
| TEST_TIME | 36 | 3530.65 | 0.9859 | 1.0117 | 1406 | 97 | 
| TEST_TIME | 37 | 3531.18 | 0.9842 | 1.0169 | 1405 | 94 | 
| TEST_TIME | 38 | 3562.18 | 0.9815 | 1.0173 | 1362 | 95 | 
| TEST_TIME | 39 | 3587.99 | 0.9841 | 1.0150 | 1272 | 97 | 
| TEST_TIME | 40 | 3626.56 | 0.9791 | 1.0249 | 1906 | 96 | 
| TEST_TIME | 41 | 3692.35 | 0.9821 | 1.0145 | 1467 | 99 | 
| TEST_TIME | 42 | 3703.88 | 0.9872 | 1.0144 | 1321 | 88 | 
| TEST_TIME | 43 | 3742.30 | 0.9810 | 1.0209 | 1824 | 92 | 
| TEST_TIME | 44 | 3810.53 | 0.9798 | 1.0191 | 1679 | 93 | 
| TEST_TIME | 45 | 3856.05 | 0.9847 | 1.0141 | 1443 | 96 | 
| TEST_TIME | 46 | 3858.65 | 0.9914 | 1.0119 | 1241 | 84 | 
| TEST_TIME | 47 | 3895.42 | 0.9810 | 1.0143 | 1387 | 96 | 
| TEST_TIME | 48 | 3924.22 | 0.9859 | 1.0165 | 1414 | 94 | 
| TEST_TIME | 49 | 3956.04 | 0.9878 | 1.0131 | 1480 | 99 | 
| TEST_TIME | 50 | 3975.20 | 0.9882 | 1.0103 | 1315 | 97 | 
| TEST_TIME | 51 | 3986.03 | 0.9881 | 1.0108 | 1430 | 96 | 
| TEST_TIME | 52 | 4001.27 | 0.9876 | 1.0104 | 1499 | 94 | 
| TEST_TIME | 53 | 4004.68 | 0.9905 | 1.0092 | 1237 | 97 | 
| TEST_TIME | 54 | 4006.88 | 0.9900 | 1.0093 | 1274 | 91 | 
| TEST_TIME | 55 | 4038.10 | 0.9833 | 1.0146 | 1882 | 95 | 
| TEST_TIME | 56 | 4086.27 | 0.9848 | 1.0180 | 1649 | 97 | 
| TEST_TIME | 57 | 4137.40 | 0.9877 | 1.0119 | 1780 | 96 | 
| TEST_TIME | 58 | 4179.29 | 0.9845 | 1.0147 | 1515 | 94 | 
| TEST_TIME | 59 | 4213.67 | 0.9894 | 1.0108 | 1411 | 93 | 
| TEST_TIME | 60 | 4248.24 | 0.9859 | 1.0099 | 1686 | 94 | 
| TEST_TIME | 61 | 4266.06 | 0.9892 | 1.0103 | 1505 | 98 | 
| TEST_TIME | 62 | 4278.22 | 0.9912 | 1.0091 | 1449 | 97 | 
| TEST_TIME | 63 | 4284.56 | 0.9917 | 1.0082 | 1358 | 91 | 
| TEST_TIME | 64 | 4302.47 | 0.9883 | 1.0090 | 1332 | 92 | 
| TEST_TIME | 65 | 4313.53 | 0.9909 | 1.0086 | 1359 | 95 | 
| TEST_TIME | 66 | 4335.89 | 0.9882 | 1.0089 | 1309 | 96 | 
| TEST_TIME | 67 | 4342.09 | 0.9925 | 1.0075 | 1389 | 92 | 
| TEST_TIME | 68 | 4349.23 | 0.9912 | 1.0086 | 1328 | 93 | 
| TEST_TIME | 69 | 4351.76 | 0.9934 | 1.0068 | 1237 | 88 | 
| TEST_TIME | 70 | 4380.39 | 0.9860 | 1.0124 | 1541 | 97 | 
| TEST_TIME | 71 | 4415.71 | 0.9902 | 1.0080 | 1634 | 93 | 
| TEST_TIME | 72 | 4427.30 | 0.9914 | 1.0110 | 1431 | 93 | 
| TEST_TIME | 73 | 4452.82 | 0.9915 | 1.0091 | 1546 | 95 | 
| TEST_TIME | 74 | 4470.92 | 0.9915 | 1.0096 | 1585 | 95 | 
| TEST_TIME | 75 | 4479.03 | 0.9943 | 1.0073 | 1325 | 85 | 
| TEST_TIME | 76 | 4485.21 | 0.9927 | 1.0078 | 1209 | 90 | 
| TEST_TIME | 77 | 4501.65 | 0.9911 | 1.0108 | 1357 | 92 | 
| TEST_TIME | 78 | 4527.36 | 0.9921 | 1.0077 | 1304 | 93 | 
| TEST_TIME | 79 | 4546.85 | 0.9909 | 1.0059 | 1187 | 90 | 
| TEST_TIME | 80 | 4555.87 | 0.9914 | 1.0079 | 1275 | 89 | 
| TEST_TIME | 81 | 4570.58 | 0.9922 | 1.0069 | 1368 | 93 | 
| TEST_TIME | 82 | 4576.98 | 0.9933 | 1.0063 | 1271 | 92 | 
| TEST_TIME | 83 | 4583.27 | 0.9928 | 1.0056 | 1157 | 88 | 
| TEST_TIME | 84 | 4589.37 | 0.9924 | 1.0081 | 1076 | 90 | 
| TEST_TIME | 85 | 4608.76 | 0.9921 | 1.0070 | 1449 | 95 | 
| TEST_TIME | 86 | 4615.73 | 0.9938 | 1.0045 | 1012 | 85 | 
| TEST_TIME | 87 | 4605.13 | 0.9953 | 1.0073 | 1263 | 88 | 
| TEST_TIME | 88 | 4624.43 | 0.9917 | 1.0072 | 1438 | 94 | 
| TEST_TIME | 89 | 4647.95 | 0.9908 | 1.0079 | 1507 | 94 | 
| TEST_TIME | 90 | 4661.11 | 0.9939 | 1.0068 | 1389 | 94 | 
| TEST_TIME | 91 | 4672.04 | 0.9935 | 1.0062 | 1432 | 95 | 
| TEST_TIME | 92 | 4676.63 | 0.9943 | 1.0053 | 1389 | 95 | 
| TEST_TIME | 93 | 4680.48 | 0.9937 | 1.0062 | 1355 | 91 | 
| TEST_TIME | 94 | 4688.75 | 0.9937 | 1.0064 | 1387 | 93 | 
| TEST_TIME | 95 | 4695.49 | 0.9944 | 1.0056 | 1227 | 89 | 
| TEST_TIME | 96 | 4701.02 | 0.9939 | 1.0059 | 1296 | 91 | 
| TEST_TIME | 97 | 4710.69 | 0.9935 | 1.0060 | 1170 | 93 | 
| TEST_TIME | 98 | 4717.22 | 0.9944 | 1.0058 | 1127 | 93 | 
| TEST_TIME | 99 | 4723.64 | 0.9943 | 1.0045 | 1207 | 92 | 
| TEST_TIME | 100 | 4727.31 | 0.9937 | 1.0055 | 1372 | 94 | 
| TEST_TIME | 101 | 4738.95 | 0.9931 | 1.0071 | 1574 | 94 | 
| TEST_TIME | 102 | 4765.64 | 0.9916 | 1.0056 | 1260 | 94 | 
| TEST_TIME | 103 | 4784.91 | 0.9919 | 1.0066 | 1355 | 94 | 
| TEST_TIME | 104 | 4798.09 | 0.9942 | 1.0060 | 1331 | 92 | 
| TEST_TIME | 105 | 4810.63 | 0.9939 | 1.0055 | 1356 | 93 | 
| TEST_TIME | 106 | 4818.69 | 0.9943 | 1.0052 | 1371 | 91 | 
| TEST_TIME | 107 | 4824.07 | 0.9947 | 1.0056 | 1315 | 90 | 
| TEST_TIME | 108 | 4836.61 | 0.9937 | 1.0061 | 1156 | 89 | 
| TEST_TIME | 109 | 4845.14 | 0.9951 | 1.0059 | 1217 | 93 | 
| TEST_TIME | 110 | 4846.73 | 0.9965 | 1.0026 | 1133 | 93 | 
| TEST_TIME | 111 | 4826.71 | 0.9977 | 1.0026 | 1074 | 77 | 
| TEST_TIME | 112 | 4813.43 | 0.9964 | 1.0039 | 1068 | 77 | 
| TEST_TIME | 113 | 4815.27 | 0.9947 | 1.0040 | 1277 | 87 | 
| TEST_TIME | 114 | 4816.23 | 0.9950 | 1.0047 | 1180 | 92 | 
| TEST_TIME | 115 | 4827.07 | 0.9938 | 1.0049 | 1431 | 91 | 
| TEST_TIME | 116 | 4832.09 | 0.9954 | 1.0047 | 1386 | 89 | 
| TEST_TIME | 117 | 4844.22 | 0.9936 | 1.0061 | 1543 | 90 | 
| TEST_TIME | 118 | 4854.46 | 0.9955 | 1.0052 | 1307 | 89 | 
| TEST_TIME | 119 | 4865.60 | 0.9945 | 1.0065 | 1397 | 93 | 
| TEST_TIME | 120 | 4881.06 | 0.9949 | 1.0047 | 1244 | 91 | 
| TEST_TIME | 121 | 4884.38 | 0.9957 | 1.0040 | 1292 | 89 | 
| TEST_TIME | 122 | 4891.20 | 0.9944 | 1.0053 | 1213 | 89 | 
| TEST_TIME | 123 | 4902.28 | 0.9949 | 1.0053 | 1123 | 86 | 
| TEST_TIME | 124 | 4909.82 | 0.9956 | 1.0065 | 1047 | 88 | 
| TEST_TIME | 125 | 4922.80 | 0.9959 | 1.0034 | 998 | 90 | 
| TEST_TIME | 126 | 4915.13 | 0.9970 | 1.0031 | 1094 | 81 | 
| TEST_TIME | 127 | 4922.34 | 0.9938 | 1.0046 | 1184 | 92 | 
| TEST_TIME | 128 | 4924.81 | 0.9962 | 1.0042 | 1130 | 92 | 
| TEST_TIME | 129 | 4925.05 | 0.9964 | 1.0042 | 1191 | 88 | 
| TEST_TIME | 130 | 4934.31 | 0.9947 | 1.0057 | 1530 | 94 | 
| TEST_TIME | 131 | 4947.33 | 0.9954 | 1.0043 | 1527 | 95 | 
| TEST_TIME | 132 | 4958.95 | 0.9944 | 1.0046 | 1420 | 94 | 
| TEST_TIME | 133 | 4965.50 | 0.9957 | 1.0042 | 1353 | 92 | 
| TEST_TIME | 134 | 4971.10 | 0.9956 | 1.0038 | 1417 | 92 | 
| TEST_TIME | 135 | 4978.56 | 0.9948 | 1.0051 | 1212 | 91 | 
| TEST_TIME | 136 | 4990.44 | 0.9954 | 1.0045 | 1325 | 89 | 
| TEST_TIME | 137 | 4997.54 | 0.9958 | 1.0040 | 1194 | 90 | 
| TEST_TIME | 138 | 5001.19 | 0.9960 | 1.0032 | 1289 | 93 | 
| TEST_TIME | 139 | 4999.47 | 0.9963 | 1.0033 | 1201 | 89 | 
| TEST_TIME | 140 | 4996.44 | 0.9967 | 1.0031 | 1142 | 89 | 
| TEST_TIME | 141 | 4994.59 | 0.9965 | 1.0038 | 1259 | 94 | 
| TEST_TIME | 142 | 4998.23 | 0.9960 | 1.0044 | 1099 | 96 | 
| TEST_TIME | 143 | 5001.29 | 0.9968 | 1.0031 | 1196 | 90 | 
| TEST_TIME | 144 | 4995.17 | 0.9974 | 1.0030 | 1185 | 91 | 
| TEST_TIME | 145 | 4992.04 | 0.9967 | 1.0043 | 1534 | 95 | 
| TEST_TIME | 146 | 4997.49 | 0.9964 | 1.0031 | 1430 | 93 | 
| TEST_TIME | 147 | 5002.22 | 0.9953 | 1.0037 | 1407 | 90 | 
| TEST_TIME | 148 | 5003.10 | 0.9968 | 1.0038 | 1242 | 92 | 
| TEST_TIME | 149 | 5002.76 | 0.9971 | 1.0027 | 1133 | 85 | 
| TEST_TIME | 150 | 5000.79 | 0.9964 | 1.0046 | 1049 | 86 | 
| TEST_TIME | 151 | 5009.03 | 0.9963 | 1.0034 | 1173 | 90 | 
| TEST_TIME | 152 | 5011.31 | 0.9964 | 1.0040 | 1058 | 90 | 
| TEST_TIME | 153 | 5017.15 | 0.9963 | 1.0034 | 1397 | 91 | 
| TEST_TIME | 154 | 5015.83 | 0.9972 | 1.0044 | 1245 | 91 | 
| TEST_TIME | 155 | 5025.95 | 0.9959 | 1.0034 | 1090 | 90 | 
| TEST_TIME | 156 | 5033.23 | 0.9955 | 1.0038 | 1086 | 91 | 
| TEST_TIME | 157 | 5031.87 | 0.9976 | 1.0026 | 1055 | 90 | 
| TEST_TIME | 158 | 5026.59 | 0.9973 | 1.0031 | 1161 | 91 | 
| TEST_TIME | 159 | 5024.13 | 0.9973 | 1.0033 | 1106 | 90 | 
| TEST_TIME | 160 | 5029.13 | 0.9961 | 1.0029 | 1193 | 91 | 
| TEST_TIME | 161 | 5020.76 | 0.9983 | 1.0016 | 867 | 71 | 
| TEST_TIME | 162 | 5011.22 | 0.9973 | 1.0035 | 1097 | 82 | 
| TEST_TIME | 163 | 5014.03 | 0.9968 | 1.0031 | 1184 | 84 | 
| TEST_TIME | 164 | 5019.31 | 0.9959 | 1.0038 | 1232 | 89 | 
| TEST_TIME | 165 | 5032.22 | 0.9952 | 1.0032 | 1387 | 95 | 
| TEST_TIME | 166 | 5031.44 | 0.9973 | 1.0030 | 1398 | 91 | 
| TEST_TIME | 167 | 5029.63 | 0.9973 | 1.0023 | 1352 | 89 | 
| TEST_TIME | 168 | 5041.09 | 0.9942 | 1.0032 | 1282 | 95 | 
| TEST_TIME | 169 | 5039.81 | 0.9975 | 1.0029 | 1171 | 92 | 
| TEST_TIME | 170 | 5039.03 | 0.9972 | 1.0027 | 1102 | 94 | 
| TEST_TIME | 171 | 5038.33 | 0.9969 | 1.0040 | 1184 | 92 | 
| TEST_TIME | 172 | 5041.91 | 0.9975 | 1.0030 | 1124 | 91 | 
| TEST_TIME | 173 | 5045.60 | 0.9966 | 1.0029 | 1029 | 90 | 
| TEST_TIME | 174 | 5042.74 | 0.9977 | 1.0027 | 1052 | 88 | 
| TEST_TIME | 175 | 5043.75 | 0.9967 | 1.0034 | 1301 | 90 | 
| TEST_TIME | 176 | 5047.50 | 0.9970 | 1.0027 | 1338 | 88 | 
| TEST_TIME | 177 | 5057.30 | 0.9951 | 1.0046 | 1472 | 92 | 
| TEST_TIME | 178 | 5065.63 | 0.9973 | 1.0029 | 1284 | 91 | 
| TEST_TIME | 179 | 5067.04 | 0.9971 | 1.0028 | 1056 | 85 | 
| TEST_TIME | 180 | 5067.52 | 0.9971 | 1.0024 | 1151 | 88 | 
| TEST_TIME | 181 | 5064.96 | 0.9973 | 1.0022 | 1237 | 87 | 
| TEST_TIME | 182 | 5063.61 | 0.9969 | 1.0022 | 1274 | 87 | 
| TEST_TIME | 183 | 5060.19 | 0.9975 | 1.0022 | 1211 | 88 | 
| TEST_TIME | 184 | 5061.23 | 0.9966 | 1.0026 | 1118 | 89 | 
| TEST_TIME | 185 | 5064.97 | 0.9964 | 1.0035 | 1161 | 90 | 
| TEST_TIME | 186 | 5067.56 | 0.9976 | 1.0032 | 1015 | 88 | 
| TEST_TIME | 187 | 5072.89 | 0.9968 | 1.0030 | 1083 | 90 | 
| TEST_TIME | 188 | 5079.06 | 0.9965 | 1.0026 | 1099 | 91 | 
| TEST_TIME | 189 | 5079.42 | 0.9972 | 1.0024 | 1096 | 92 | 
| TEST_TIME | 190 | 5070.01 | 0.9990 | 1.0047 | 189 | 100 | 
 
Done for 15830 ms, from  7:02:10.52 to  7:02:26.35.  
 
 
| 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 | 5418 | 3523 | 2809 | <null> | 3352 | <null> | 6121 | <null> | 8924 | 1540 | 5477 | 1812 | 8494 | <null> | 43330 | 1752 | 195204 | 250692 | <null> | 03:56:06 | 04:14:06 | 
| fetches per second | 2 | 1642 | 5009 | 2752 | 2874 | 2999 | <null> | 5881 | 2861 | 3336 | 3047 | 2931 | 2650 | 15694 | <null> | 18873 | <null> | 241679 | 167723 | <null> | 04:14:07 | 04:32:07 | 
| fetches per second | 3 | 1596 | 4138 | 2847 | <null> | 3346 | 3316 | 6689 | 3163 | 10878 | 2793 | 5014 | 2068 | 13849 | 2586 | 22266 | 3693 | 261735 | 137632 | <null> | 04:32:08 | 04:50:08 | 
| fetches per second | 4 | 1665 | 4614 | 3066 | <null> | 3622 | <null> | 7682 | <null> | 10283 | 2864 | 3495 | 3153 | 18082 | 2281 | 17021 | <null> | 310143 | 217157 | <null> | 04:50:09 | 05:08:09 | 
| fetches per second | 5 | 1555 | 4380 | 3210 | <null> | 3501 | 2462 | 7325 | 4360 | 9375 | 3095 | 2926 | 3177 | 17264 | 2267 | 23720 | 1755 | 325770 | <null> | <null> | 05:08:10 | 05:26:10 | 
| fetches per second | 6 | 1510 | 4146 | 3962 | 2408 | 4303 | 2460 | 8388 | 3483 | 16017 | 2623 | 7578 | 2835 | 21871 | 2397 | 19559 | 2221 | 336705 | 219619 | <null> | 05:26:11 | 05:44:11 | 
| fetches per second | 7 | 1561 | 4795 | 3290 | <null> | 3970 | 2488 | 8195 | 3190 | 17915 | 3520 | 4202 | 2073 | 17583 | 3703 | 21974 | 2215 | 291778 | 258262 | <null> | 05:44:12 | 06:02:12 | 
| fetches per second | 8 | 1411 | 5368 | 3762 | <null> | 5022 | 2570 | 9321 | 3834 | 15863 | 2369 | 4928 | 2693 | 18750 | 2198 | 23489 | 2885 | <null> | 228916 | <null> | 06:02:13 | 06:20:13 | 
| fetches per second | 9 | 1635 | 3835 | 3360 | <null> | 3652 | 2598 | 8177 | 3394 | 4944 | 2375 | 4368 | 2349 | 30952 | 2067 | 18002 | 2127 | 309643 | 214712 | <null> | 06:20:14 | 06:38:14 | 
| fetches per second | 10 | 1524 | 4080 | 3481 | <null> | 4089 | <null> | 8174 | 3414 | 29236 | 2379 | 4247 | 1857 | 27012 | 1591 | 16571 | 1739 | 347668 | 289625 | <null> | 06:38:15 | 06:56:15 | 
| marks per second | 1 | 1069 | 422 | 281 | <null> | 260 | <null> | 352 | <null> | 405 | 333 | 953 | 278 | 440 | <null> | 1106 | 290 | 1709 | 711 | <null> | 03:56:06 | 04:14:06 | 
| marks per second | 2 | 329 | 610 | 288 | 637 | 296 | <null> | 402 | 404 | 331 | 498 | 417 | 408 | 497 | <null> | 510 | <null> | 1495 | 721 | <null> | 04:14:07 | 04:32:07 | 
| marks per second | 3 | 316 | 548 | 271 | <null> | 312 | 710 | 412 | 439 | 371 | 381 | 493 | 291 | 512 | 448 | 541 | 526 | 1235 | 728 | <null> | 04:32:08 | 04:50:08 | 
| marks per second | 4 | 321 | 584 | 272 | <null> | 292 | <null> | 361 | <null> | 648 | 381 | 454 | 487 | 435 | 438 | 489 | <null> | 2298 | 1189 | <null> | 04:50:09 | 05:08:09 | 
| marks per second | 5 | 301 | 557 | 276 | <null> | 334 | 553 | 392 | 580 | 411 | 495 | 395 | 464 | 455 | 345 | 451 | 297 | 1231 | <null> | <null> | 05:08:10 | 05:26:10 | 
| marks per second | 6 | 297 | 554 | 285 | 551 | 291 | 552 | 382 | 466 | 488 | 369 | 411 | 462 | 390 | 312 | 434 | 400 | 1183 | 396 | <null> | 05:26:11 | 05:44:11 | 
| marks per second | 7 | 308 | 612 | 270 | <null> | 334 | 573 | 406 | 405 | 371 | 520 | 425 | 342 | 1087 | 543 | 485 | 394 | 1355 | 2494 | <null> | 05:44:12 | 06:02:12 | 
| marks per second | 8 | 282 | 725 | 277 | <null> | 262 | 560 | 395 | 509 | 384 | 379 | 382 | 373 | 426 | 323 | 489 | 526 | <null> | 570 | <null> | 06:02:13 | 06:20:13 | 
| marks per second | 9 | 314 | 472 | 278 | <null> | 296 | 627 | 412 | 454 | 876 | 392 | 394 | 348 | 375 | 317 | 423 | 345 | 1489 | 755 | <null> | 06:20:14 | 06:38:14 | 
| marks per second | 10 | 303 | 500 | 267 | <null> | 275 | <null> | 513 | 467 | 515 | 360 | 401 | 261 | 362 | 217 | 410 | 333 | 1194 | 775 | <null> | 06:38:15 | 06:56:15 | 
| reads/fetches*100 | 1 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | <null> | 03:56:06 | 04:14:06 | 
| reads/fetches*100 | 2 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | <null> | 04:14:07 | 04:32:07 | 
| reads/fetches*100 | 3 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 04:32:08 | 04:50:08 | 
| reads/fetches*100 | 4 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | <null> | 04:50:09 | 05:08:09 | 
| reads/fetches*100 | 5 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | <null> | 05:08:10 | 05:26:10 | 
| reads/fetches*100 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 05:26:11 | 05:44:11 | 
| reads/fetches*100 | 7 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 05:44:12 | 06:02:12 | 
| reads/fetches*100 | 8 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:02:13 | 06:20:13 | 
| reads/fetches*100 | 9 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 06:20:14 | 06:38:14 | 
| reads/fetches*100 | 10 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 06:38:15 | 06:56:15 | 
| writes/marks*100 | 1 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 1 | 1 | 0 | 0 | 0 | <null> | 0 | 0 | 6 | 0 | <null> | 03:56:06 | 04:14:06 | 
| writes/marks*100 | 2 | 0 | 0 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 1 | 0 | 0 | 0 | <null> | 0 | <null> | 2 | 0 | <null> | 04:14:07 | 04:32:07 | 
| writes/marks*100 | 3 | 1 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 4 | 0 | <null> | 04:32:08 | 04:50:08 | 
| writes/marks*100 | 4 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | <null> | 1 | 0 | 0 | 0 | 0 | 0 | 0 | <null> | 5 | 1 | <null> | 04:50:09 | 05:08:09 | 
| writes/marks*100 | 5 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | <null> | <null> | 05:08:10 | 05:26:10 | 
| writes/marks*100 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 0 | <null> | 05:26:11 | 05:44:11 | 
| writes/marks*100 | 7 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 05:44:12 | 06:02:12 | 
| writes/marks*100 | 8 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | <null> | 0 | <null> | 06:02:13 | 06:20:13 | 
| writes/marks*100 | 9 | 0 | 0 | 0 | <null> | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | <null> | 06:20:14 | 06:38:14 | 
| writes/marks*100 | 10 | 0 | 0 | 0 | <null> | 0 | <null> | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | <null> | 06:38:15 | 06:56:15 | 
 
Done for 15050 ms, from  7:02:27.50 to  7:02:42.55.  
 
 
| 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 | 1594838 | 1547625 | 47213 | 2.96 | 0 | 13564 | 24 | 47213 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| doc_list_biud | 1595245 | 1547624 | 47621 | 2.98 | 0 | 18292 | 44 | 47621 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_add_invoice_to_stock | 17309 | 11518 | 5791 | 33.45 | 26 | 229457 | 21866 | 5791 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_adding_invoice | 3581 | 2917 | 664 | 18.54 | 119 | 153637 | 4907 | 664 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_client_order | 5927 | 5648 | 279 | 4.70 | 3 | 2252 | 76 | 279 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_customer_reserve | 192187 | 148873 | 43314 | 22.53 | 1 | 18335 | 142 | 43314 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_pay_from_customer | 2310 | 2282 | 28 | 1.21 | 3 | 3356 | 103 | 28 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_pay_to_supplier | 1376 | 1353 | 23 | 1.67 | 9 | 967 | 143 | 23 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_supplier_invoice | 7588 | 6350 | 1238 | 16.31 | 38 | 9780 | 2440 | 1238 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_supplier_order | 1404 | 429 | 975 | 69.44 | 43 | 454396 | 78523 | 975 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_cancel_write_off | 12081 | 9257 | 2824 | 23.37 | 2 | 2721 | 229 | 2824 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_client_order | 72171 | 72171 | 0 | 0.00 | 5 | 18832 | 1033 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_customer_reserve | 561877 | 561877 | 0 | 0.00 | 1 | 23227 | 382 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_fill_shopping_cart | 109026 | 109026 | 0 | 0.00 | 1 | 13395 | 215 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_fill_shopping_cart_clo_res | 561877 | 561877 | 0 | 0.00 | 0 | 5979 | 1 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_get_clo_for_invoice | 11518 | 11518 | 0 | 0.00 | 1 | 17921 | 1043 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_kill_cost_storno | 19023 | 15809 | 3214 | 16.89 | 0 | 3265 | 80 | 3214 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_kill_qstorno_ret_qs2qd | 403767 | 313782 | 89985 | 22.28 | 0 | 10059 | 111 | 89985 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_kill_qty_storno | 265599 | 218078 | 47521 | 17.89 | 0 | 18289 | 306 | 47521 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_lock_selected_doc | 70841 | 61869 | 8972 | 12.66 | 0 | 692 | 3 | 8972 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_make_cost_storno | 88603 | 88603 | 0 | 0.00 | 0 | 10671 | 228 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_multiply_rows_for_pdistr | 88602 | 88602 | 0 | 0.00 | 0 | 4271 | 147 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_multiply_rows_for_qdistr | 72174 | 72174 | 0 | 0.00 | 0 | 17860 | 766 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_pay_from_customer | 24197 | 24197 | 0 | 0.00 | 15 | 8183 | 306 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_pay_to_supplier | 19800 | 19800 | 0 | 0.00 | 12 | 15685 | 670 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_payment_common | 43997 | 43997 | 0 | 0.00 | 2 | 7171 | 33 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_qd_handle_on_cancel_clo | 5926 | 5648 | 278 | 4.69 | 0 | 550 | 50 | 278 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_qd_handle_on_invoice_upd_sts | 14915 | 14435 | 480 | 3.21 | 1 | 8043 | 1831 | 480 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_qd_handle_on_reserve_upd_sts | 33087 | 33086 | 1 | 0.00 | 0 | 3820 | 132 | 1 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_reserve_write_off | 34145 | 33086 | 1059 | 3.10 | 6 | 17672 | 337 | 1059 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_supplier_invoice | 18559 | 18559 | 0 | 0.00 | 30 | 48392 | 11491 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| sp_supplier_order | 18296 | 18296 | 0 | 0.00 | 11 | 29185 | 7396 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| srv_find_qd_qs_mism | 906225 | 859059 | 47166 | 5.20 | 0 | 2729 | 2 | 47166 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| srv_make_invnt_saldo | 3842 | 3842 | 0 | 0.00 | 166 | 44394 | 1319 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| srv_make_money_saldo | 4189 | 4189 | 0 | 0.00 | 3 | 1763 | 56 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 2299 | 20024 | 4690 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_add_invoice_to_stock | 5791 | 5791 | 0 | 0.00 | 1 | 680 | 143 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_adding_invoice | 547 | 547 | 0 | 0.00 | 10 | 2812 | 1144 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_client_order | 279 | 279 | 0 | 0.00 | 49 | 461 | 223 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_customer_reserve | 78 | 78 | 0 | 0.00 | 21 | 311 | 145 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_pay_from_customer | 28 | 28 | 0 | 0.00 | 105 | 404 | 213 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_pay_to_supplier | 23 | 23 | 0 | 0.00 | 45 | 369 | 231 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_supplier_invoice | 446 | 446 | 0 | 0.00 | 2 | 501 | 137 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_supplier_order | 5889 | 5889 | 0 | 0.00 | 6 | 4301 | 1523 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_cancel_write_off | 63 | 63 | 0 | 0.00 | 72 | 289 | 146 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-abend:sp_reserve_write_off | 1059 | 1059 | 0 | 0.00 | 1 | 1557 | 141 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_add_invoice_to_stock | 11579 | 11579 | 0 | 0.00 | 2 | 48698 | 10688 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_adding_invoice | 1198 | 1198 | 0 | 0.00 | 20 | 31995 | 9004 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_client_order | 5648 | 5648 | 0 | 0.00 | 0 | 1745 | 253 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_customer_reserve | 2205 | 2205 | 0 | 0.00 | 1 | 641 | 279 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_pay_from_customer | 2282 | 2282 | 0 | 0.00 | 0 | 711 | 196 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_pay_to_supplier | 1353 | 1353 | 0 | 0.00 | 1 | 574 | 196 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_supplier_invoice | 909 | 909 | 0 | 0.00 | 2 | 1492 | 249 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_supplier_order | 429 | 429 | 0 | 0.00 | 3 | 336874 | 48818 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_cancel_write_off | 3241 | 3241 | 0 | 0.00 | 0 | 785 | 277 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_client_order | 72179 | 72179 | 0 | 0.00 | 0 | 2781 | 336 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_customer_reserve | 3378 | 3378 | 0 | 0.00 | 0 | 811 | 186 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_pay_from_customer | 24197 | 24197 | 0 | 0.00 | 0 | 1787 | 227 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_pay_to_supplier | 19803 | 19803 | 0 | 0.00 | 0 | 2399 | 226 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_reserve_write_off | 33087 | 33087 | 0 | 0.00 | 0 | 1920 | 309 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_supplier_invoice | 18568 | 18568 | 0 | 0.00 | 1 | 1996 | 338 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:sp_supplier_order | 18302 | 18302 | 0 | 0.00 | 0 | 2384 | 339 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:srv_make_invnt_saldo | 3842 | 3842 | 0 | 0.00 | 0 | 233 | 28 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:srv_make_money_saldo | 4189 | 4189 | 0 | 0.00 | 0 | 324 | 31 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| t$perf-norm:srv_recalc_idx_stat | 12 | 12 | 0 | 0.00 | 886 | 2509 | 1391 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_add_invoice_to_stock | 34618 | 23036 | 11582 | 33.45 | 0 | 415 | 5 | 11582 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_all_customers | 108832 | 108832 | 0 | 0.00 | 0 | 283 | 5 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_all_suppliers | 74184 | 74184 | 0 | 0.00 | 0 | 195 | 6 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_all_wares | 144342 | 144342 | 0 | 0.00 | 0 | 278 | 9 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_adding_invoice | 2856 | 2396 | 460 | 16.10 | 0 | 525 | 54 | 460 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_client_order | 11854 | 11296 | 558 | 4.70 | 0 | 119 | 5 | 558 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_customer_prepayment | 4620 | 4564 | 56 | 1.21 | 0 | 126 | 5 | 56 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_customer_reserve | 4566 | 4410 | 156 | 3.41 | 0 | 167 | 6 | 156 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_payment_to_supplier | 2752 | 2706 | 46 | 1.67 | 1 | 83 | 6 | 46 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_supplier_invoice | 2710 | 1818 | 892 | 32.91 | 0 | 77 | 6 | 892 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_supplier_order | 2808 | 858 | 1950 | 69.44 | 1 | 103 | 6 | 1950 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_cancel_write_off | 6608 | 6482 | 126 | 1.90 | 0 | 405 | 29 | 126 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_max_id_clo_ord | 18296 | 18296 | 0 | 0.00 | 0 | 774 | 16 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_max_id_clo_res | 3378 | 3378 | 0 | 0.00 | 1 | 243 | 22 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_max_id_ord_sup | 18559 | 18559 | 0 | 0.00 | 0 | 458 | 16 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_max_non_paid_invoice | 19563 | 19563 | 0 | 0.00 | 0 | 677 | 7 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_max_non_paid_realizn | 24197 | 24197 | 0 | 0.00 | 0 | 732 | 6 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_min_id_clo_ord | 18296 | 18296 | 0 | 0.00 | 0 | 482 | 11 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_min_id_clo_res | 3378 | 3378 | 0 | 0.00 | 0 | 2468 | 12 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_min_id_ord_sup | 18559 | 18559 | 0 | 0.00 | 0 | 319 | 12 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_min_non_paid_invoice | 19800 | 19800 | 0 | 0.00 | 0 | 7153 | 26 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_min_non_paid_realizn | 24197 | 24197 | 0 | 0.00 | 0 | 685 | 5 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_our_firm | 35510 | 35510 | 0 | 0.00 | 0 | 244 | 5 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| v_reserve_write_off | 68290 | 66172 | 2118 | 3.10 | 0 | 407 | 5 | 2118 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| x_lock_depdocs_on_canc_invoice | 12939 | 8358 | 4581 | 35.40 | 0 | 1237 | 8 | 4581 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| x_lock_depdocs_on_canc_sup_ord | 1402 | 429 | 973 | 69.40 | 0 | 80 | 5 | 973 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| x_make_qstorno_1000_1200 | 18296 | 18296 | 0 | 0.00 | 3 | 25709 | 6848 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| x_make_qstorno_1200_2000 | 18561 | 18561 | 0 | 0.00 | 22 | 47640 | 10981 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| x_make_qstorno_2100_3300 | 561877 | 561877 | 0 | 0.00 | 0 | 23140 | 379 | 0 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
 
Done for 248580 ms, from  7:07:21.78 to  7:11:30.36.  
 
 
 
| FB_MNEMONA | CNT | UNIT | FB_GDSCODE | DTS_BEG | DTS_END | 
| deadlock | 130 | sp_kill_cost_storno | 335544336 | 2016-11-27 03:56 | 2016-11-27 06:46 | 
| deadlock | 12 | sp_kill_qstorno_ret_qs2qd | 335544336 | 2016-11-27 04:02 | 2016-11-27 06:15 | 
| deadlock | 84 | sp_lock_selected_doc | 335544336 | 2016-11-27 03:59 | 2016-11-27 06:52 | 
| deadlock | 278 | sp_qd_handle_on_cancel_clo | 335544336 | 2016-11-27 03:56 | 2016-11-27 06:55 | 
| deadlock | 80 | sp_qd_handle_on_invoice_upd_sts | 335544336 | 2016-11-27 03:56 | 2016-11-27 06:46 | 
| deadlock | 1 | sp_qd_handle_on_reserve_upd_sts | 335544336 | 2016-11-27 04:02 | 2016-11-27 04:02 | 
| deadlock | 2 | x_lock_depdocs_on_canc_invoice | 335544336 | 2016-11-27 04:14 | 2016-11-27 05:28 | 
| concurrent_transaction | 7386 | sp_lock_selected_doc | 335544878 | 2016-11-27 03:56 | 2016-11-27 06:56 | 
| concurrent_transaction | 489 | x_lock_depdocs_on_canc_invoice | 335544878 | 2016-11-27 03:56 | 2016-11-27 06:54 | 
| concurrent_transaction | 507 | x_lock_depdocs_on_canc_sup_ord | 335544878 | 2016-11-27 03:56 | 2016-11-27 06:55 | 
 
Done for 7070 ms, from  7:11:37.70 to  7:11:44.77.  
  
MON$DATABASE_NAME               D:\OLTP-EMUL\OLTP30-SMALL.FDB
 
MON$PAGE_SIZE                   8192
 
MON$ODS_MAJOR                   12
 
MON$ODS_MINOR                   0
 
MON$OLDEST_TRANSACTION          337912
 
MON$OLDEST_ACTIVE               337913
 
MON$OLDEST_SNAPSHOT             337913
 
MON$NEXT_TRANSACTION            337913
 
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               2015-12-11 13:07:49.8140
 
MON$PAGES                       713984
 
MON$STAT_ID                     1
 
MON$BACKUP_STATE                0
 
MON$CRYPT_PAGE                  0
 
MON$OWNER                       SYSDBA                                                                                       
 
MON$SEC_DATABASE                Default
 
ISQL Version: WI-V3.0.2.32641 Firebird 3.0
 
Server version:
 
Firebird/Windows/AMD/Intel/x64 (access method), version "WI-V3.0.2.32641 Firebird 3.0"
 
Firebird/Windows/AMD/Intel/x64 (remote server), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
 
Firebird/Windows/AMD/Intel/x64 (remote interface), version "WI-V3.0.2.32641 Firebird 3.0/tcp (WIN-2BE1UI8LGDL)/P14"
 
on disk structure version 12.0 
 
Database "D:\OLTP-EMUL\OLTP30-SMALL.FDB" 
 
Database header page information: 
 
Flags			0 
 
Generation		338264 
 
System Change Number	0 
 
Page size		8192 
 
ODS version		12.0 
 
Oldest transaction	337914 
 
Oldest active		337915 
 
Oldest snapshot		337915 
 
Next transaction	337916 
 
Sequence number		0 
 
Next attachment ID	5156 
 
Implementation		HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc 
 
Shadow count		0 
 
Page buffers		0 
 
Next header page	0 
 
Database dialect	3 
 
Creation date		Dec 11, 2015 13:07:49 
 
Attributes		force write 
 
 
Variable header data: 
 
Sweep interval:		0 
 
*END* 
 
 
 
Database file sequence: 
 
File D:\OLTP-EMUL\OLTP30-SMALL.FDB is the only file 
 
 
Analyzing database pages ... 
 
AGENTS (154) 
 
Primary pointer page: 311, Index root page: 312 
 
Total formats: 1, used formats: 1 
 
Average record length: 34.24, 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.05 
 
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: 322, 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: 324, 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: 323, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 3.08, total dup: 48, max dup: 45 
 
Average key length: 2.04, compression ratio: 0.53 
 
Average prefix length: 1.02, 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: 321, depth: 1, leaf buckets: 1, nodes: 50 
 
Average node length: 17.92, total dup: 0, max dup: 0 
 
Average key length: 16.60, compression ratio: 0.92 
 
Average prefix length: 1.34, average data length: 13.92 
 
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: 320, 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: 332, Index root page: 333 
 
Total formats: 1, used formats: 1 
 
Average record length: 103.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: 996.00, compression ratio: 9.67 
 
Pointer pages: 1, data page slots: 1 
 
Data pages: 1, average fill: 28% 
 
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: 336, 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: 337, 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: 335, 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: 251, Index root page: 252 
 
Total formats: 1, used formats: 1 
 
Average record length: 47.06, total records: 1691869 
 
Average version length: 47.74, total versions: 8840, 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: 12, data page slots: 18936 
 
Data pages: 18936, average fill: 71% 
 
Primary pages: 18936, secondary pages: 0, swept pages: 13312 
 
Empty pages: 0, full pages: 7532 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 272 
 
60 - 79% = 18664 
 
80 - 99% = 0 
 
 
Index DOC_DATA_DOC_WARE_UNQ (1) 
 
Root page: 19783, depth: 3, leaf buckets: 7778, nodes: 1691869 
 
Average node length: 20.00, total dup: 0, max dup: 0 
 
Average key length: 17.06, compression ratio: 1.58 
 
Average prefix length: 12.94, average data length: 14.06 
 
Clustering factor: 669634, ratio: 0.40 
 
Fill distribution: 
 
0 - 19% = 252 
 
20 - 39% = 399 
 
40 - 59% = 5053 
 
60 - 79% = 1448 
 
80 - 99% = 626 
 
 
Index DOC_DATA_ID_DESC (2) 
 
Root page: 46992, depth: 3, leaf buckets: 6010, nodes: 1691869 
 
Average node length: 11.61, total dup: 0, max dup: 0 
 
Average key length: 8.67, compression ratio: 1.04 
 
Average prefix length: 3.33, average data length: 5.67 
 
Clustering factor: 615135, ratio: 0.36 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2837 
 
40 - 59% = 3170 
 
60 - 79% = 3 
 
80 - 99% = 0 
 
 
Index FK_DOC_DATA_DOC_LIST (3) 
 
Root page: 97996, depth: 3, leaf buckets: 3150, nodes: 1691869 
 
Average node length: 7.18, total dup: 1148565, max dup: 49 
 
Average key length: 4.24, compression ratio: 2.12 
 
Average prefix length: 7.08, average data length: 1.92 
 
Clustering factor: 627962, ratio: 0.37 
 
Fill distribution: 
 
0 - 19% = 79 
 
20 - 39% = 534 
 
40 - 59% = 2231 
 
60 - 79% = 100 
 
80 - 99% = 206 
 
 
DOC_LIST (140) 
 
Primary pointer page: 247, Index root page: 248 
 
Total formats: 1, used formats: 1 
 
Average record length: 59.94, total records: 594192 
 
Average version length: 36.38, total versions: 6244, max versions: 4 
 
Average fragment length: 7.63, total fragments: 73, max fragments: 1 
 
Average unpacked length: 96.00, compression ratio: 1.60 
 
Pointer pages: 5, data page slots: 7840 
 
Data pages: 7840, average fill: 72% 
 
Primary pages: 7831, secondary pages: 9, swept pages: 6709 
 
Empty pages: 5, full pages: 4508 
 
Fill distribution: 
 
0 - 19% = 15 
 
20 - 39% = 5 
 
40 - 59% = 178 
 
60 - 79% = 7595 
 
80 - 99% = 47 
 
 
Index DOC_LIST_ID_DESC (1) 
 
Root page: 228962, depth: 3, leaf buckets: 2256, nodes: 594192 
 
Average node length: 11.78, total dup: 0, max dup: 0 
 
Average key length: 8.92, compression ratio: 1.01 
 
Average prefix length: 3.08, average data length: 5.92 
 
Clustering factor: 176887, ratio: 0.30 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 1359 
 
40 - 59% = 895 
 
60 - 79% = 2 
 
80 - 99% = 0 
 
 
Index FK_DOC_LIST_AGENTS (2) 
 
Root page: 2964, depth: 2, leaf buckets: 663, nodes: 594192 
 
Average node length: 4.87, total dup: 594142, max dup: 44584 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 285343, ratio: 0.48 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 2 
 
40 - 59% = 604 
 
60 - 79% = 39 
 
80 - 99% = 18 
 
 
Index PK_DOC_LIST (0) 
 
Root page: 255127, depth: 3, leaf buckets: 2124, nodes: 594192 
 
Average node length: 11.78, total dup: 0, max dup: 0 
 
Average key length: 8.92, compression ratio: 1.01 
 
Average prefix length: 3.08, average data length: 5.92 
 
Clustering factor: 176887, ratio: 0.30 
 
Fill distribution: 
 
0 - 19% = 53 
 
20 - 39% = 1035 
 
40 - 59% = 959 
 
60 - 79% = 4 
 
80 - 99% = 73 
 
 
DOC_STATES (153) 
 
Primary pointer page: 309, Index root page: 310 
 
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: 318, 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: 319, 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: 317, 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: 338, Index root page: 339 
 
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: 340, 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: 269, Index root page: 270 
 
Total formats: 1, used formats: 1 
 
Average record length: 64.12, total records: 400 
 
Average version length: 0.00, total versions: 0, max versions: 0 
 
Average fragment length: 17.69, total fragments: 399, max fragments: 1 
 
Average unpacked length: 104.00, compression ratio: 1.62 
 
Pointer pages: 3, data page slots: 1518 
 
Data pages: 28, average fill: 24% 
 
Primary pages: 4, secondary pages: 24, swept pages: 4 
 
Empty pages: 12, full pages: 3 
 
Fill distribution: 
 
0 - 19% = 16 
 
20 - 39% = 7 
 
40 - 59% = 1 
 
60 - 79% = 1 
 
80 - 99% = 3 
 
 
Index PK_INVNT_SALDO (0) 
 
Root page: 281, 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: 262, ratio: 0.66 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
INVNT_TURNOVER_LOG (157) 
 
Primary pointer page: 330, Index root page: 331 
 
Total formats: 1, used formats: 1 
 
Average record length: 65.90, total records: 11259 
 
Average version length: 71.19, total versions: 819, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 96.00, compression ratio: 1.46 
 
Pointer pages: 3, data page slots: 3912 
 
Data pages: 2152, average fill: 8% 
 
Primary pages: 2151, secondary pages: 1, swept pages: 2115 
 
Empty pages: 234, full pages: 12 
 
Fill distribution: 
 
0 - 19% = 2066 
 
20 - 39% = 56 
 
40 - 59% = 16 
 
60 - 79% = 12 
 
80 - 99% = 2 
 
 
Index INVNT_TURNOVER_LOG_WARE_DD_ID (0) 
 
Root page: 997, depth: 2, leaf buckets: 53, nodes: 11259 
 
Average node length: 14.32, total dup: 1309, max dup: 1 
 
Average key length: 11.41, compression ratio: 2.37 
 
Average prefix length: 18.47, average data length: 8.53 
 
Clustering factor: 9281, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 31 
 
40 - 59% = 17 
 
60 - 79% = 4 
 
80 - 99% = 0 
 
 
MONEY_SALDO (143) 
 
Primary pointer page: 261, Index root page: 262 
 
Total formats: 1, used formats: 1 
 
Average record length: 15.10, 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.12 
 
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: 272, 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: 259, Index root page: 260 
 
Total formats: 1, used formats: 1 
 
Average record length: 4.42, total records: 2311 
 
Average version length: 45.52, total versions: 2099, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 64.00, compression ratio: 14.49 
 
Pointer pages: 1, data page slots: 136 
 
Data pages: 119, average fill: 23% 
 
Primary pages: 118, secondary pages: 1, swept pages: 36 
 
Empty pages: 34, full pages: 13 
 
Fill distribution: 
 
0 - 19% = 86 
 
20 - 39% = 8 
 
40 - 59% = 8 
 
60 - 79% = 5 
 
80 - 99% = 12 
 
 
Index MONEY_TURNOVER_LOG_AGENT_OPTYPE (0) 
 
Root page: 94637, depth: 2, leaf buckets: 5, nodes: 2311 
 
Average node length: 4.31, total dup: 2234, max dup: 281 
 
Average key length: 2.44, compression ratio: 7.79 
 
Average prefix length: 18.59, average data length: 0.41 
 
Clustering factor: 1164, ratio: 0.50 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 4 
 
40 - 59% = 0 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
MON_LOG (164) 
 
Primary pointer page: 352, Index root page: 353 
 
Total formats: 2, 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: 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 
 
 
Index MON_LOG_GDSCODE (2) 
 
Root page: 361, 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: 360, 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: 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 
 
 
Index PK_MON_LOG (0) 
 
Root page: 359, 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 (165) 
 
Primary pointer page: 364, Index root page: 365 
 
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: 370, 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: 368, 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: 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_TABLE_STATS_TN_UNIT (3) 
 
Root page: 369, 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: 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 
 
 
OPTYPES (138) 
 
Primary pointer page: 239, Index root page: 240 
 
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: 242, 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: 241, 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: 293, Index root page: 294 
 
Total formats: 1, used formats: 1 
 
Average record length: 41.24, total records: 250349 
 
Average version length: 32.01, total versions: 10135, max versions: 14 
 
Average fragment length: 33.45, total fragments: 44, max fragments: 1 
 
Average unpacked length: 64.00, compression ratio: 1.55 
 
Pointer pages: 3, data page slots: 3504 
 
Data pages: 3504, average fill: 55% 
 
Primary pages: 3468, secondary pages: 36, swept pages: 2822 
 
Empty pages: 13, full pages: 291 
 
Fill distribution: 
 
0 - 19% = 116 
 
20 - 39% = 510 
 
40 - 59% = 1261 
 
60 - 79% = 1584 
 
80 - 99% = 33 
 
 
Index PDISTR_AGENT_ID (4) 
 
Root page: 3600, depth: 2, leaf buckets: 237, nodes: 250349 
 
Average node length: 4.63, total dup: 250300, max dup: 12176 
 
Average key length: 2.01, compression ratio: 4.48 
 
Average prefix length: 8.99, average data length: 0.01 
 
Clustering factor: 35936, ratio: 0.14 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 23 
 
40 - 59% = 100 
 
60 - 79% = 83 
 
80 - 99% = 31 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_ASC (2) 
 
Root page: 4281, depth: 2, leaf buckets: 288, nodes: 250349 
 
Average node length: 5.60, total dup: 225300, max dup: 29 
 
Average key length: 2.98, compression ratio: 7.38 
 
Average prefix length: 21.12, average data length: 0.88 
 
Clustering factor: 42442, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 34 
 
40 - 59% = 114 
 
60 - 79% = 89 
 
80 - 99% = 51 
 
 
Index PDISTR_SNDOP_RCVOP_SNDID_DESC (3) 
 
Root page: 3974, depth: 2, leaf buckets: 290, nodes: 250349 
 
Average node length: 5.61, total dup: 225300, max dup: 29 
 
Average key length: 2.98, compression ratio: 7.38 
 
Average prefix length: 21.12, average data length: 0.88 
 
Clustering factor: 42587, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 29 
 
40 - 59% = 112 
 
60 - 79% = 114 
 
80 - 99% = 35 
 
 
Index PDISTR_SND_ID (1) 
 
Root page: 4313, depth: 2, leaf buckets: 306, nodes: 250349 
 
Average node length: 5.39, total dup: 225300, max dup: 29 
 
Average key length: 2.76, compression ratio: 3.26 
 
Average prefix length: 8.34, average data length: 0.66 
 
Clustering factor: 42540, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 54 
 
40 - 59% = 148 
 
60 - 79% = 74 
 
80 - 99% = 28 
 
 
PERF_ESTIMATED (160) 
 
Primary pointer page: 341, Index root page: 342 
 
Total formats: 1, used formats: 1 
 
Average record length: 27.88, total records: 254567 
 
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: 2176 
 
Data pages: 2176, average fill: 64% 
 
Primary pages: 2176, secondary pages: 0, swept pages: 0 
 
Empty pages: 3, full pages: 2172 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 2172 
 
80 - 99% = 0 
 
 
Index PERF_EST_MINUTE_SINCE_START (0) 
 
Root page: 460731, depth: 2, leaf buckets: 204, nodes: 254567 
 
Average node length: 4.50, total dup: 254376, max dup: 2677 
 
Average key length: 2.00, compression ratio: 1.29 
 
Average prefix length: 2.58, average data length: 0.00 
 
Clustering factor: 32619, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 68 
 
60 - 79% = 82 
 
80 - 99% = 54 
 
 
PERF_ISQL_STAT (161) 
 
Primary pointer page: 344, Index root page: 345 
 
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: 346, 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 (162) 
 
Primary pointer page: 348, Index root page: 349 
 
Total formats: 2, used formats: 2 
 
Average record length: 148.78, total records: 9354168 
 
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: 1440.09, compression ratio: 9.68 
 
Pointer pages: 134, data page slots: 218080 
 
Data pages: 218080, average fill: 87% 
 
Primary pages: 218080, secondary pages: 0, swept pages: 3 
 
Empty pages: 2, full pages: 218077 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 218077 
 
 
Index PERF_LOG_DTS_BEG_DESC (0) 
 
Root page: 59394, depth: 3, leaf buckets: 10411, nodes: 9354168 
 
Average node length: 6.03, total dup: 4043621, max dup: 14 
 
Average key length: 2.68, compression ratio: 2.98 
 
Average prefix length: 7.37, average data length: 0.63 
 
Clustering factor: 7404808, ratio: 0.79 
 
Fill distribution: 
 
0 - 19% = 13 
 
20 - 39% = 0 
 
40 - 59% = 4061 
 
60 - 79% = 3971 
 
80 - 99% = 2366 
 
 
Index PERF_LOG_GDSCODE (3) 
 
Root page: 162370, depth: 3, leaf buckets: 8972, nodes: 9354168 
 
Average node length: 4.39, total dup: 9354163, max dup: 8959032 
 
Average key length: 1.04, compression ratio: 0.20 
 
Average prefix length: 0.21, average data length: 0.00 
 
Clustering factor: 364779, ratio: 0.04 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 8944 
 
60 - 79% = 0 
 
80 - 99% = 28 
 
 
Index PERF_LOG_TRN_DESC (2) 
 
Root page: 43359, depth: 3, leaf buckets: 10385, nodes: 9354168 
 
Average node length: 5.59, total dup: 9053922, max dup: 11660 
 
Average key length: 2.24, compression ratio: 4.02 
 
Average prefix length: 8.79, average data length: 0.21 
 
Clustering factor: 4721732, ratio: 0.50 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 2 
 
40 - 59% = 6219 
 
60 - 79% = 2381 
 
80 - 99% = 1780 
 
 
Index PERF_LOG_UNIT (1) 
 
Root page: 65474, depth: 3, leaf buckets: 10627, nodes: 9354168 
 
Average node length: 5.56, total dup: 9197459, max dup: 1041888 
 
Average key length: 2.21, compression ratio: 17.04 
 
Average prefix length: 37.46, average data length: 0.19 
 
Clustering factor: 6710120, ratio: 0.72 
 
Fill distribution: 
 
0 - 19% = 36 
 
20 - 39% = 4 
 
40 - 59% = 7475 
 
60 - 79% = 1506 
 
80 - 99% = 1606 
 
 
PHRASES (145) 
 
Primary pointer page: 265, Index root page: 266 
 
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: 279, 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: 278, 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: 277, 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: 276, 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: 301, Index root page: 302 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.33, total records: 311373 
 
Average version length: 55.43, total versions: 3614, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 80.00, compression ratio: 1.47 
 
Pointer pages: 3, data page slots: 3864 
 
Data pages: 3864, average fill: 71% 
 
Primary pages: 3864, secondary pages: 0, swept pages: 2832 
 
Empty pages: 2, full pages: 2492 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 29 
 
40 - 59% = 194 
 
60 - 79% = 3618 
 
80 - 99% = 13 
 
 
Index PSTORNED_RCV_ID (2) 
 
Root page: 2296, depth: 2, leaf buckets: 422, nodes: 311373 
 
Average node length: 6.00, total dup: 256525, max dup: 365 
 
Average key length: 3.30, compression ratio: 2.72 
 
Average prefix length: 7.87, average data length: 1.13 
 
Clustering factor: 33602, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 2 
 
20 - 39% = 16 
 
40 - 59% = 289 
 
60 - 79% = 101 
 
80 - 99% = 14 
 
 
Index PSTORNED_SND_ID (1) 
 
Root page: 2211, depth: 2, leaf buckets: 336, nodes: 311373 
 
Average node length: 5.53, total dup: 277466, max dup: 343 
 
Average key length: 2.83, compression ratio: 3.18 
 
Average prefix length: 8.28, average data length: 0.72 
 
Clustering factor: 67357, ratio: 0.22 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 2 
 
40 - 59% = 148 
 
60 - 79% = 140 
 
80 - 99% = 45 
 
 
RULES_FOR_PDISTR (152) 
 
Primary pointer page: 303, Index root page: 304 
 
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: 308, 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: 243, Index root page: 244 
 
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: 246, 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: 245, 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: 315, Index root page: 316 
 
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: 327, 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: 328, 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: 236, Index root page: 237 
 
Total formats: 1, used formats: 1 
 
Average record length: 98.32, 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: 81% 
 
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: 238, depth: 1, leaf buckets: 1, nodes: 114 
 
Average node length: 27.07, total dup: 0, max dup: 0 
 
Average key length: 26.06, compression ratio: 1.70 
 
Average prefix length: 21.23, average data length: 23.07 
 
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: 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$AUTOGEN$SOURCE (135) 
 
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$DEP_DOCS (129) 
 
Primary pointer page: 198, Index root page: 199 
 
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: 200, 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: 207, Index root page: 224 
 
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: 226, 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: 227, Index root page: 228 
 
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: 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$PERF_LOG (163) 
 
Primary pointer page: 350, Index root page: 351 
 
Total formats: 2, 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: 358, 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: 205, Index root page: 206 
 
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: 201, Index root page: 202 
 
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: 204, 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: 203, 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: 193, Index root page: 194 
 
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: 197, 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 (276) 
 
Primary pointer page: 557, Index root page: 68921 
 
Total formats: 1, used formats: 1 
 
Average record length: 54.33, total records: 2830 
 
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: 136.00, compression ratio: 2.50 
 
Pointer pages: 1, data page slots: 40 
 
Data pages: 40, average fill: 62% 
 
Primary pages: 40, secondary pages: 0, swept pages: 0 
 
Empty pages: 7, full pages: 32 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 33 
 
80 - 99% = 0 
 
 
WARES (144) 
 
Primary pointer page: 263, Index root page: 264 
 
Total formats: 1, used formats: 1 
 
Average record length: 77.53, 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.78 
 
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: 374, depth: 1, leaf buckets: 1, nodes: 400 
 
Average node length: 3.17, total dup: 392, max dup: 64 
 
Average key length: 2.16, compression ratio: 4.16 
 
Average prefix length: 8.86, average data length: 0.14 
 
Clustering factor: 48, 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: 273, 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: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_ID_DESC (2) 
 
Root page: 275, 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: 328, ratio: 0.82 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 1 
 
60 - 79% = 0 
 
80 - 99% = 0 
 
 
Index WARES_NUMB_UNQ (1) 
 
Root page: 504, depth: 2, leaf buckets: 3, nodes: 400 
 
Average node length: 52.95, total dup: 0, max dup: 0 
 
Average key length: 51.92, compression ratio: 0.99 
 
Average prefix length: 2.65, average data length: 48.95 
 
Clustering factor: 334, ratio: 0.83 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 0 
 
40 - 59% = 0 
 
60 - 79% = 1 
 
80 - 99% = 2 
 
 
WARE_GROUPS (155) 
 
Primary pointer page: 313, Index root page: 314 
 
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: 325, 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: 326, 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 (259) 
 
Primary pointer page: 254, Index root page: 284 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.94, total records: 3682 
 
Average version length: 72.09, total versions: 57, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.92 
 
Pointer pages: 5, data page slots: 5608 
 
Data pages: 456, average fill: 10% 
 
Primary pages: 455, secondary pages: 1, swept pages: 400 
 
Empty pages: 288, full pages: 8 
 
Fill distribution: 
 
0 - 19% = 375 
 
20 - 39% = 39 
 
40 - 59% = 23 
 
60 - 79% = 19 
 
80 - 99% = 0 
 
 
Index XQD_1000_1200_WARE_SOP_ROP_SND (0) 
 
Root page: 1235, depth: 2, leaf buckets: 10, nodes: 3682 
 
Average node length: 7.76, total dup: 3184, max dup: 14 
 
Average key length: 4.99, compression ratio: 7.41 
 
Average prefix length: 34.14, average data length: 2.86 
 
Clustering factor: 566, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 1 
 
20 - 39% = 6 
 
40 - 59% = 2 
 
60 - 79% = 1 
 
80 - 99% = 0 
 
 
XQD_1000_3300 (261) 
 
Primary pointer page: 708, Index root page: 709 
 
Total formats: 1, used formats: 1 
 
Average record length: 70.16, total records: 1366038 
 
Average version length: 71.85, total versions: 37929, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.94 
 
Pointer pages: 14, data page slots: 22136 
 
Data pages: 22136, average fill: 69% 
 
Primary pages: 22136, secondary pages: 0, swept pages: 15767 
 
Empty pages: 36, full pages: 11788 
 
Fill distribution: 
 
0 - 19% = 141 
 
20 - 39% = 870 
 
40 - 59% = 2892 
 
60 - 79% = 17758 
 
80 - 99% = 475 
 
 
Index XQD_1000_3300_DOC (1) 
 
Root page: 185728, depth: 3, leaf buckets: 1770, nodes: 1366038 
 
Average node length: 5.16, total dup: 1329165, max dup: 125 
 
Average key length: 2.21, compression ratio: 4.08 
 
Average prefix length: 8.82, average data length: 0.18 
 
Clustering factor: 291089, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 27 
 
20 - 39% = 128 
 
40 - 59% = 1488 
 
60 - 79% = 101 
 
80 - 99% = 26 
 
 
Index XQD_1000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 115735, depth: 3, leaf buckets: 2038, nodes: 1366038 
 
Average node length: 6.29, total dup: 1191570, max dup: 29 
 
Average key length: 3.33, compression ratio: 11.10 
 
Average prefix length: 35.79, average data length: 1.21 
 
Clustering factor: 364077, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 31 
 
20 - 39% = 183 
 
40 - 59% = 1577 
 
60 - 79% = 138 
 
80 - 99% = 109 
 
 
XQD_1200_2000 (260) 
 
Primary pointer page: 705, Index root page: 706 
 
Total formats: 1, used formats: 1 
 
Average record length: 68.63, total records: 49969 
 
Average version length: 72.11, total versions: 2147, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.98 
 
Pointer pages: 8, data page slots: 9872 
 
Data pages: 4072, average fill: 15% 
 
Primary pages: 4072, secondary pages: 0, swept pages: 3735 
 
Empty pages: 1535, full pages: 24 
 
Fill distribution: 
 
0 - 19% = 2825 
 
20 - 39% = 794 
 
40 - 59% = 370 
 
60 - 79% = 78 
 
80 - 99% = 5 
 
 
Index XQD_1200_2000_WARE_SOP_ROP_SND (0) 
 
Root page: 178621, depth: 3, leaf buckets: 111, nodes: 49969 
 
Average node length: 6.56, total dup: 43369, max dup: 48 
 
Average key length: 3.63, compression ratio: 10.20 
 
Average prefix length: 35.50, average data length: 1.50 
 
Clustering factor: 8383, ratio: 0.17 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 72 
 
40 - 59% = 34 
 
60 - 79% = 4 
 
80 - 99% = 1 
 
 
XQD_2000_3300 (262) 
 
Primary pointer page: 729, Index root page: 730 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.19, total records: 1450018 
 
Average version length: 71.89, total versions: 100487, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.02 
 
Pointer pages: 21, data page slots: 32808 
 
Data pages: 32768, average fill: 51% 
 
Primary pages: 32768, secondary pages: 0, swept pages: 26405 
 
Empty pages: 308, full pages: 4501 
 
Fill distribution: 
 
0 - 19% = 1489 
 
20 - 39% = 7458 
 
40 - 59% = 13538 
 
60 - 79% = 9326 
 
80 - 99% = 957 
 
 
Index XQD_2000_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 110774, depth: 3, leaf buckets: 2342, nodes: 1450018 
 
Average node length: 5.63, total dup: 1362718, max dup: 91 
 
Average key length: 2.66, compression ratio: 13.90 
 
Average prefix length: 36.40, average data length: 0.60 
 
Clustering factor: 460371, ratio: 0.32 
 
Fill distribution: 
 
0 - 19% = 26 
 
20 - 39% = 1142 
 
40 - 59% = 770 
 
60 - 79% = 289 
 
80 - 99% = 115 
 
 
XQD_2100_3300 (263) 
 
Primary pointer page: 734, Index root page: 735 
 
Total formats: 1, used formats: 1 
 
Average record length: 4.44, total records: 26823 
 
Average version length: 71.98, total versions: 25124, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 30.65 
 
Pointer pages: 6, data page slots: 8800 
 
Data pages: 2464, average fill: 15% 
 
Primary pages: 2462, secondary pages: 2, swept pages: 1691 
 
Empty pages: 1550, full pages: 254 
 
Fill distribution: 
 
0 - 19% = 1915 
 
20 - 39% = 198 
 
40 - 59% = 69 
 
60 - 79% = 79 
 
80 - 99% = 203 
 
 
Index XQD_2100_3300_WARE_SOP_ROP_SND (0) 
 
Root page: 1530, depth: 2, leaf buckets: 53, nodes: 26823 
 
Average node length: 6.34, total dup: 24143, max dup: 49 
 
Average key length: 3.48, compression ratio: 10.63 
 
Average prefix length: 35.62, average data length: 1.38 
 
Clustering factor: 3490, ratio: 0.13 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 30 
 
40 - 59% = 18 
 
60 - 79% = 5 
 
80 - 99% = 0 
 
 
XQD_3300_3400 (264) 
 
Primary pointer page: 737, Index root page: 738 
 
Total formats: 1, used formats: 1 
 
Average record length: 69.75, total records: 2228473 
 
Average version length: 71.02, total versions: 56916, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.95 
 
Pointer pages: 22, data page slots: 34760 
 
Data pages: 34760, average fill: 70% 
 
Primary pages: 34760, secondary pages: 0, swept pages: 25012 
 
Empty pages: 35, full pages: 16546 
 
Fill distribution: 
 
0 - 19% = 82 
 
20 - 39% = 233 
 
40 - 59% = 3252 
 
60 - 79% = 30545 
 
80 - 99% = 648 
 
 
Index XQD_3300_3400_WARE_SOP_ROP_SND (0) 
 
Root page: 41262, depth: 3, leaf buckets: 4722, nodes: 2228473 
 
Average node length: 6.96, total dup: 1784593, max dup: 25 
 
Average key length: 3.99, compression ratio: 9.28 
 
Average prefix length: 35.21, average data length: 1.79 
 
Clustering factor: 624664, ratio: 0.28 
 
Fill distribution: 
 
0 - 19% = 5 
 
20 - 39% = 2566 
 
40 - 59% = 1836 
 
60 - 79% = 205 
 
80 - 99% = 110 
 
 
XQS_1000_1200 (265) 
 
Primary pointer page: 740, Index root page: 741 
 
Total formats: 1, used formats: 1 
 
Average record length: 83.60, total records: 3804456 
 
Average version length: 84.01, total versions: 17104, 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: 37, data page slots: 59624 
 
Data pages: 59624, average fill: 79% 
 
Primary pages: 59624, secondary pages: 0, swept pages: 31191 
 
Empty pages: 6, full pages: 56164 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 0 
 
40 - 59% = 117 
 
60 - 79% = 30174 
 
80 - 99% = 29327 
 
 
Index XQS_1000_1200_DOC_ID (0) 
 
Root page: 54649, depth: 3, leaf buckets: 3689, nodes: 3804456 
 
Average node length: 5.16, total dup: 3716634, max dup: 133 
 
Average key length: 2.17, compression ratio: 4.14 
 
Average prefix length: 8.85, average data length: 0.15 
 
Clustering factor: 877736, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 10 
 
20 - 39% = 35 
 
40 - 59% = 1405 
 
60 - 79% = 1444 
 
80 - 99% = 795 
 
 
Index XQS_1000_1200_RCV_ID (2) 
 
Root page: 78654, depth: 3, leaf buckets: 5021, nodes: 3804456 
 
Average node length: 5.65, total dup: 3434786, max dup: 49 
 
Average key length: 2.66, compression ratio: 3.38 
 
Average prefix length: 8.43, average data length: 0.57 
 
Clustering factor: 590328, ratio: 0.16 
 
Fill distribution: 
 
0 - 19% = 48 
 
20 - 39% = 124 
 
40 - 59% = 3979 
 
60 - 79% = 405 
 
80 - 99% = 465 
 
 
Index XQS_1000_1200_SND_ID (1) 
 
Root page: 48486, depth: 3, leaf buckets: 4182, nodes: 3804456 
 
Average node length: 5.79, total dup: 3328584, max dup: 29 
 
Average key length: 2.81, compression ratio: 3.20 
 
Average prefix length: 8.31, average data length: 0.69 
 
Clustering factor: 927006, ratio: 0.24 
 
Fill distribution: 
 
0 - 19% = 4 
 
20 - 39% = 49 
 
40 - 59% = 1793 
 
60 - 79% = 1379 
 
80 - 99% = 957 
 
 
XQS_1000_3300 (267) 
 
Primary pointer page: 750, Index root page: 751 
 
Total formats: 1, used formats: 1 
 
Average record length: 80.83, total records: 1570427 
 
Average version length: 82.85, total versions: 40998, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.68 
 
Pointer pages: 16, data page slots: 25984 
 
Data pages: 25984, average fill: 75% 
 
Primary pages: 25984, secondary pages: 0, swept pages: 18444 
 
Empty pages: 23, full pages: 18130 
 
Fill distribution: 
 
0 - 19% = 65 
 
20 - 39% = 137 
 
40 - 59% = 1474 
 
60 - 79% = 16838 
 
80 - 99% = 7470 
 
 
Index XQS_1000_3300_DOC_ID (0) 
 
Root page: 75516, depth: 3, leaf buckets: 1743, nodes: 1570427 
 
Average node length: 5.14, total dup: 1533540, max dup: 210 
 
Average key length: 2.18, compression ratio: 4.12 
 
Average prefix length: 8.84, average data length: 0.16 
 
Clustering factor: 327908, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 30 
 
40 - 59% = 1101 
 
60 - 79% = 515 
 
80 - 99% = 97 
 
 
Index XQS_1000_3300_RCV_ID (2) 
 
Root page: 131765, depth: 3, leaf buckets: 3017, nodes: 1570427 
 
Average node length: 6.29, total dup: 1274100, max dup: 14 
 
Average key length: 3.33, compression ratio: 2.70 
 
Average prefix length: 7.86, average data length: 1.14 
 
Clustering factor: 239914, ratio: 0.15 
 
Fill distribution: 
 
0 - 19% = 57 
 
20 - 39% = 1578 
 
40 - 59% = 1138 
 
60 - 79% = 209 
 
80 - 99% = 35 
 
 
Index XQS_1000_3300_SND_ID (1) 
 
Root page: 65477, depth: 3, leaf buckets: 1920, nodes: 1570427 
 
Average node length: 5.78, total dup: 1376870, max dup: 41 
 
Average key length: 2.82, compression ratio: 3.19 
 
Average prefix length: 8.30, average data length: 0.70 
 
Clustering factor: 353899, ratio: 0.23 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 29 
 
40 - 59% = 1186 
 
60 - 79% = 540 
 
80 - 99% = 162 
 
 
XQS_1200_2000 (266) 
 
Primary pointer page: 745, Index root page: 746 
 
Total formats: 1, used formats: 1 
 
Average record length: 81.70, total records: 4112330 
 
Average version length: 85.42, total versions: 116505, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.66 
 
Pointer pages: 43, data page slots: 70040 
 
Data pages: 70024, average fill: 73% 
 
Primary pages: 70024, secondary pages: 0, swept pages: 38834 
 
Empty pages: 30, full pages: 46646 
 
Fill distribution: 
 
0 - 19% = 167 
 
20 - 39% = 1285 
 
40 - 59% = 5944 
 
60 - 79% = 42150 
 
80 - 99% = 20478 
 
 
Index XQS_1200_2000_DOC_ID (0) 
 
Root page: 57323, depth: 3, leaf buckets: 4720, nodes: 4112330 
 
Average node length: 5.04, total dup: 4088850, max dup: 599 
 
Average key length: 2.05, compression ratio: 4.38 
 
Average prefix length: 8.95, average data length: 0.05 
 
Clustering factor: 1111096, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 6 
 
20 - 39% = 478 
 
40 - 59% = 2957 
 
60 - 79% = 1057 
 
80 - 99% = 222 
 
 
Index XQS_1200_2000_RCV_ID (2) 
 
Root page: 78658, depth: 3, leaf buckets: 5835, nodes: 4112330 
 
Average node length: 5.49, total dup: 3811602, max dup: 49 
 
Average key length: 2.51, compression ratio: 3.59 
 
Average prefix length: 8.57, average data length: 0.43 
 
Clustering factor: 875892, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 39 
 
20 - 39% = 2126 
 
40 - 59% = 2697 
 
60 - 79% = 426 
 
80 - 99% = 547 
 
 
Index XQS_1200_2000_SND_ID (1) 
 
Root page: 49624, depth: 3, leaf buckets: 5234, nodes: 4112330 
 
Average node length: 5.62, total dup: 3730041, max dup: 109 
 
Average key length: 2.63, compression ratio: 3.42 
 
Average prefix length: 8.46, average data length: 0.54 
 
Clustering factor: 1178384, ratio: 0.29 
 
Fill distribution: 
 
0 - 19% = 8 
 
20 - 39% = 430 
 
40 - 59% = 3413 
 
60 - 79% = 1100 
 
80 - 99% = 283 
 
 
XQS_2000_3300 (268) 
 
Primary pointer page: 757, Index root page: 758 
 
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: 760, 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: 762, 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: 761, 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 (269) 
 
Primary pointer page: 763, Index root page: 764 
 
Total formats: 1, used formats: 1 
 
Average record length: 82.11, total records: 2700521 
 
Average version length: 84.12, total versions: 55926, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 1.66 
 
Pointer pages: 28, data page slots: 45024 
 
Data pages: 45024, average fill: 75% 
 
Primary pages: 45024, secondary pages: 0, swept pages: 31251 
 
Empty pages: 23, full pages: 30036 
 
Fill distribution: 
 
0 - 19% = 64 
 
20 - 39% = 125 
 
40 - 59% = 1899 
 
60 - 79% = 31627 
 
80 - 99% = 11309 
 
 
Index XQS_2100_3300_DOC_ID (0) 
 
Root page: 92254, depth: 3, leaf buckets: 2974, nodes: 2700521 
 
Average node length: 5.02, total dup: 2687064, max dup: 1007 
 
Average key length: 2.05, compression ratio: 4.40 
 
Average prefix length: 8.96, average data length: 0.04 
 
Clustering factor: 707931, ratio: 0.26 
 
Fill distribution: 
 
0 - 19% = 14 
 
20 - 39% = 371 
 
40 - 59% = 1540 
 
60 - 79% = 738 
 
80 - 99% = 311 
 
 
Index XQS_2100_3300_RCV_ID (2) 
 
Root page: 98176, depth: 3, leaf buckets: 5471, nodes: 2700521 
 
Average node length: 6.31, total dup: 2186545, max dup: 14 
 
Average key length: 3.34, compression ratio: 2.70 
 
Average prefix length: 7.85, average data length: 1.15 
 
Clustering factor: 572826, ratio: 0.21 
 
Fill distribution: 
 
0 - 19% = 175 
 
20 - 39% = 3091 
 
40 - 59% = 1939 
 
60 - 79% = 205 
 
80 - 99% = 61 
 
 
Index XQS_2100_3300_SND_ID (1) 
 
Root page: 78028, depth: 3, leaf buckets: 3172, nodes: 2700521 
 
Average node length: 5.53, total dup: 2484351, max dup: 99 
 
Average key length: 2.56, compression ratio: 3.52 
 
Average prefix length: 8.52, average data length: 0.48 
 
Clustering factor: 741768, ratio: 0.27 
 
Fill distribution: 
 
0 - 19% = 7 
 
20 - 39% = 303 
 
40 - 59% = 1531 
 
60 - 79% = 1000 
 
80 - 99% = 331 
 
 
XQS_3300_3400 (270) 
 
Primary pointer page: 776, Index root page: 777 
 
Total formats: 1, used formats: 1 
 
Average record length: 67.78, total records: 483662 
 
Average version length: 69.35, total versions: 10624, max versions: 1 
 
Average fragment length: 0.00, total fragments: 0, max fragments: 0 
 
Average unpacked length: 136.00, compression ratio: 2.01 
 
Pointer pages: 5, data page slots: 6792 
 
Data pages: 6792, average fill: 76% 
 
Primary pages: 6792, secondary pages: 0, swept pages: 4789 
 
Empty pages: 12, full pages: 5981 
 
Fill distribution: 
 
0 - 19% = 23 
 
20 - 39% = 33 
 
40 - 59% = 140 
 
60 - 79% = 6356 
 
80 - 99% = 240 
 
 
Index XQS_3300_3400_DOC_ID (0) 
 
Root page: 545921, depth: 3, leaf buckets: 553, nodes: 483662 
 
Average node length: 5.37, total dup: 450295, max dup: 165 
 
Average key length: 2.53, compression ratio: 3.56 
 
Average prefix length: 8.54, average data length: 0.46 
 
Clustering factor: 45068, ratio: 0.09 
 
Fill distribution: 
 
0 - 19% = 3 
 
20 - 39% = 59 
 
40 - 59% = 251 
 
60 - 79% = 175 
 
80 - 99% = 65 
 
 
Index XQS_3300_3400_SND_ID (1) 
 
Root page: 374849, depth: 3, leaf buckets: 626, nodes: 483662 
 
Average node length: 5.93, total dup: 411313, max dup: 29 
 
Average key length: 3.10, compression ratio: 2.91 
 
Average prefix length: 8.05, average data length: 0.95 
 
Clustering factor: 52420, ratio: 0.11 
 
Fill distribution: 
 
0 - 19% = 0 
 
20 - 39% = 76 
 
40 - 59% = 303 
 
60 - 79% = 195 
 
80 - 99% = 52 
 
 
ZDOC_DATA (229) 
 
Primary pointer page: 632, Index root page: 633 
 
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 (228) 
 
Primary pointer page: 630, Index root page: 631 
 
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 (230) 
 
Primary pointer page: 634, Index root page: 635 
 
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 (233) 
 
Primary pointer page: 640, Index root page: 641 
 
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: 650, 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 (234) 
 
Primary pointer page: 642, Index root page: 643 
 
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: 651, 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 (231) 
 
Primary pointer page: 636, Index root page: 637 
 
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: 644, 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: 645, 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 (232) 
 
Primary pointer page: 638, Index root page: 639 
 
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: 647, 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: 646, 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: 649, 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: 648, 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 (227) 
 
Primary pointer page: 628, Index root page: 629 
 
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 (226) 
 
Primary pointer page: 625, Index root page: 626 
 
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: 267, Index root page: 268 
 
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: 280, 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 111230 ms, from  7:11:45.16 to  7:13:36.39. 
 
 
 
| TABLE_NAME | TOTAL_RECS | TOTAL_VERS | VERS_PERCENT | 
| AGENTS | 50 | 0 | 0.0000 | 
| BUSINESS_OPS | 19 | 0 | 0.0000 | 
| DOC_DATA | 1691869 | 8840 | 0.5224 | 
| DOC_LIST | 594192 | 6244 | 1.0508 | 
| DOC_STATES | 4 | 0 | 0.0000 | 
| FB_ERRORS | 758 | 0 | 0.0000 | 
| INVNT_SALDO | 400 | 0 | 0.0000 | 
| INVNT_TURNOVER_LOG | 11259 | 819 | 7.2741 | 
| MONEY_SALDO | 49 | 0 | 0.0000 | 
| MONEY_TURNOVER_LOG | 2311 | 2099 | 90.8264 | 
| OPTYPES | 9 | 0 | 0.0000 | 
| PDISTR | 250349 | 10135 | 4.0483 | 
| PERF_ESTIMATED | 254567 | 0 | 0.0000 | 
| PERF_LOG | 9354168 | 0 | 0.0000 | 
| PSTORNED | 311373 | 3614 | 1.1606 | 
| 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 | 2830 | 0 | 0.0000 | 
| WARES | 400 | 0 | 0.0000 | 
| WARE_GROUPS | 8 | 0 | 0.0000 | 
| XQD_1000_1200 | 3682 | 57 | 1.5480 | 
| XQD_1000_3300 | 1366038 | 37929 | 2.7765 | 
| XQD_1200_2000 | 49969 | 2147 | 4.2966 | 
| XQD_2000_3300 | 1450018 | 100487 | 6.9300 | 
| XQD_2100_3300 | 26823 | 25124 | 93.6658 | 
| XQD_3300_3400 | 2228473 | 56916 | 2.5540 | 
| XQS_1000_1200 | 3804456 | 17104 | 0.4495 | 
| XQS_1000_3300 | 1570427 | 40998 | 2.6106 | 
| XQS_1200_2000 | 4112330 | 116505 | 2.8330 | 
| XQS_2100_3300 | 2700521 | 55926 | 2.0709 | 
| XQS_3300_3400 | 483662 | 10624 | 2.1965 | 
| Z_USED_VIEWS | 29 | 0 | 0.0000 | 
 
Done for 2970 ms, from  7:13:48.20 to  7:13:51.17.  
07:13:51.31 Validation started 
 
 
07:13:51.32 Relation 140 (DOC_LIST) 
 
07:13:51.32   process pointer page    0 of    5 
 
07:13:51.43   process pointer page    1 of    5 
 
07:13:51.55   process pointer page    2 of    5 
 
07:13:51.65   process pointer page    3 of    5 
 
07:13:51.76   process pointer page    4 of    5 
 
07:13:51.85 Index 1 (PK_DOC_LIST) 
 
07:13:52.12 Index 2 (DOC_LIST_ID_DESC) 
 
07:13:52.41 Index 3 (FK_DOC_LIST_AGENTS) 
 
07:13:52.59 Relation 140 (DOC_LIST) is ok 
 
 
07:13:52.59 Relation 141 (DOC_DATA) 
 
07:13:52.59   process pointer page    0 of   12 
 
07:13:52.68   process pointer page    1 of   12 
 
07:13:52.77   process pointer page    2 of   12 
 
07:13:52.83   process pointer page    3 of   12 
 
07:13:52.87   process pointer page    4 of   12 
 
07:13:52.90   process pointer page    5 of   12 
 
07:13:52.94   process pointer page    6 of   12 
 
07:13:53.00   process pointer page    7 of   12 
 
07:13:53.09   process pointer page    8 of   12 
 
07:13:53.18   process pointer page    9 of   12 
 
07:13:53.27   process pointer page   10 of   12 
 
07:13:53.36   process pointer page   11 of   12 
 
07:13:53.42 Index 2 (DOC_DATA_DOC_WARE_UNQ) 
 
07:13:54.13 Index 3 (DOC_DATA_ID_DESC) 
 
07:13:54.79 Index 4 (FK_DOC_DATA_DOC_LIST) 
 
07:13:55.24 Relation 141 (DOC_DATA) is ok 
 
 
07:13:55.24 Relation 147 (INVNT_SALDO) 
 
07:13:55.24   process pointer page    0 of    3 
 
07:13:55.24   process pointer page    1 of    3 
 
07:13:55.24   process pointer page    2 of    3 
 
07:13:55.24 Index 1 (PK_INVNT_SALDO) 
 
07:13:55.24 Relation 147 (INVNT_SALDO) is ok 
 
 
07:13:55.24 Relation 150 (PDISTR) 
 
07:13:55.24   process pointer page    0 of    3 
 
07:13:55.28   process pointer page    1 of    3 
 
07:13:55.33   process pointer page    2 of    3 
 
07:13:55.34 Index 2 (PDISTR_SND_ID) 
 
07:13:55.43 Index 3 (PDISTR_SNDOP_RCVOP_SNDID_ASC) 
 
07:13:55.48 Index 4 (PDISTR_SNDOP_RCVOP_SNDID_DESC) 
 
07:13:55.53 Index 5 (PDISTR_AGENT_ID) 
 
07:13:55.60 Relation 150 (PDISTR) is ok 
 
 
07:13:55.60 Relation 151 (PSTORNED) 
 
07:13:55.60   process pointer page    0 of    3 
 
07:13:55.70   process pointer page    1 of    3 
 
07:13:55.74   process pointer page    2 of    3 
 
07:13:55.76 Index 2 (PSTORNED_SND_ID) 
 
07:13:55.79 Index 3 (PSTORNED_RCV_ID) 
 
07:13:55.83 Relation 151 (PSTORNED) is ok 
 
 
07:13:55.83 Relation 156 (SEMAPHORES) 
 
07:13:55.83   process pointer page    0 of    1 
 
07:13:55.83 Index 1 (PK_SEMAPHORES) 
 
07:13:55.83 Index 2 (SEMAPHORES_TASK_UNQ) 
 
07:13:55.83 Relation 156 (SEMAPHORES) is ok 
 
 
07:13:55.83 Relation 157 (INVNT_TURNOVER_LOG) 
 
07:13:55.83   process pointer page    0 of    3 
 
07:13:55.83   process pointer page    1 of    3 
 
07:13:55.85   process pointer page    2 of    3 
 
07:13:55.86 Index 1 (INVNT_TURNOVER_LOG_WARE_DD_ID) 
 
07:13:55.86 Relation 157 (INVNT_TURNOVER_LOG) is ok 
 
 
07:13:55.86 Relation 160 (PERF_ESTIMATED) 
 
07:13:55.86   process pointer page    0 of    2 
 
07:13:55.90   process pointer page    1 of    2 
 
07:13:55.91 Index 1 (PERF_EST_MINUTE_SINCE_START) 
 
07:13:55.93 Relation 160 (PERF_ESTIMATED) is ok 
 
 
07:13:55.93 Relation 161 (PERF_ISQL_STAT) 
 
07:13:55.93   process pointer page    0 of    1 
 
07:13:55.93 Index 1 (PERF_ISQL_STAT_TRN) 
 
07:13:55.93 Relation 161 (PERF_ISQL_STAT) is ok 
 
 
07:13:55.93 Relation 162 (PERF_LOG) 
 
07:13:55.93   process pointer page    0 of  134 
 
07:13:55.96   process pointer page    1 of  134 
 
07:13:55.99   process pointer page    2 of  134 
 
07:13:56.02   process pointer page    3 of  134 
 
07:13:56.05   process pointer page    4 of  134 
 
07:13:56.08   process pointer page    5 of  134 
 
07:13:56.12   process pointer page    6 of  134 
 
07:13:56.15   process pointer page    7 of  134 
 
07:13:56.21   process pointer page    8 of  134 
 
07:13:56.30   process pointer page    9 of  134 
 
07:13:56.38   process pointer page   10 of  134 
 
07:13:56.46   process pointer page   11 of  134 
 
07:13:56.54   process pointer page   12 of  134 
 
07:13:56.62   process pointer page   13 of  134 
 
07:13:56.69   process pointer page   14 of  134 
 
07:13:56.77   process pointer page   15 of  134 
 
07:13:56.85   process pointer page   16 of  134 
 
07:13:56.92   process pointer page   17 of  134 
 
07:13:56.95   process pointer page   18 of  134 
 
07:13:57.01   process pointer page   19 of  134 
 
07:13:57.08   process pointer page   20 of  134 
 
07:13:57.16   process pointer page   21 of  134 
 
07:13:57.24   process pointer page   22 of  134 
 
07:13:57.32   process pointer page   23 of  134 
 
07:13:57.39   process pointer page   24 of  134 
 
07:13:57.47   process pointer page   25 of  134 
 
07:13:57.55   process pointer page   26 of  134 
 
07:13:57.63   process pointer page   27 of  134 
 
07:13:57.71   process pointer page   28 of  134 
 
07:13:57.79   process pointer page   29 of  134 
 
07:13:57.86   process pointer page   30 of  134 
 
07:13:57.94   process pointer page   31 of  134 
 
07:13:57.98   process pointer page   32 of  134 
 
07:13:58.01   process pointer page   33 of  134 
 
07:13:58.04   process pointer page   34 of  134 
 
07:13:58.07   process pointer page   35 of  134 
 
07:13:58.11   process pointer page   36 of  134 
 
07:13:58.14   process pointer page   37 of  134 
 
07:13:58.18   process pointer page   38 of  134 
 
07:13:58.26   process pointer page   39 of  134 
 
07:13:58.32   process pointer page   40 of  134 
 
07:13:58.35   process pointer page   41 of  134 
 
07:13:58.42   process pointer page   42 of  134 
 
07:13:58.50   process pointer page   43 of  134 
 
07:13:58.54   process pointer page   44 of  134 
 
07:13:58.57   process pointer page   45 of  134 
 
07:13:58.60   process pointer page   46 of  134 
 
07:13:58.63   process pointer page   47 of  134 
 
07:13:58.66   process pointer page   48 of  134 
 
07:13:58.74   process pointer page   49 of  134 
 
07:13:58.82   process pointer page   50 of  134 
 
07:13:58.89   process pointer page   51 of  134 
 
07:13:58.97   process pointer page   52 of  134 
 
07:13:59.05   process pointer page   53 of  134 
 
07:13:59.13   process pointer page   54 of  134 
 
07:13:59.21   process pointer page   55 of  134 
 
07:13:59.29   process pointer page   56 of  134 
 
07:13:59.36   process pointer page   57 of  134 
 
07:13:59.39   process pointer page   58 of  134 
 
07:13:59.42   process pointer page   59 of  134 
 
07:13:59.46   process pointer page   60 of  134 
 
07:13:59.53   process pointer page   61 of  134 
 
07:13:59.60   process pointer page   62 of  134 
 
07:13:59.64   process pointer page   63 of  134 
 
07:13:59.68   process pointer page   64 of  134 
 
07:13:59.76   process pointer page   65 of  134 
 
07:13:59.84   process pointer page   66 of  134 
 
07:13:59.92   process pointer page   67 of  134 
 
07:13:59.99   process pointer page   68 of  134 
 
07:14:00.07   process pointer page   69 of  134 
 
07:14:00.15   process pointer page   70 of  134 
 
07:14:00.23   process pointer page   71 of  134 
 
07:14:00.30   process pointer page   72 of  134 
 
07:14:00.38   process pointer page   73 of  134 
 
07:14:00.46   process pointer page   74 of  134 
 
07:14:00.54   process pointer page   75 of  134 
 
07:14:00.61   process pointer page   76 of  134 
 
07:14:00.69   process pointer page   77 of  134 
 
07:14:00.77   process pointer page   78 of  134 
 
07:14:00.82   process pointer page   79 of  134 
 
07:14:00.85   process pointer page   80 of  134 
 
07:14:00.89   process pointer page   81 of  134 
 
07:14:00.92   process pointer page   82 of  134 
 
07:14:00.95   process pointer page   83 of  134 
 
07:14:01.01   process pointer page   84 of  134 
 
07:14:01.09   process pointer page   85 of  134 
 
07:14:01.16   process pointer page   86 of  134 
 
07:14:01.24   process pointer page   87 of  134 
 
07:14:01.32   process pointer page   88 of  134 
 
07:14:01.39   process pointer page   89 of  134 
 
07:14:01.47   process pointer page   90 of  134 
 
07:14:01.55   process pointer page   91 of  134 
 
07:14:01.62   process pointer page   92 of  134 
 
07:14:01.70   process pointer page   93 of  134 
 
07:14:01.78   process pointer page   94 of  134 
 
07:14:01.86   process pointer page   95 of  134 
 
07:14:01.94   process pointer page   96 of  134 
 
07:14:02.01   process pointer page   97 of  134 
 
07:14:02.07   process pointer page   98 of  134 
 
07:14:02.10   process pointer page   99 of  134 
 
07:14:02.13   process pointer page  100 of  134 
 
07:14:02.16   process pointer page  101 of  134 
 
07:14:02.19   process pointer page  102 of  134 
 
07:14:02.22   process pointer page  103 of  134 
 
07:14:02.25   process pointer page  104 of  134 
 
07:14:02.28   process pointer page  105 of  134 
 
07:14:02.30   process pointer page  106 of  134 
 
07:14:02.37   process pointer page  107 of  134 
 
07:14:02.45   process pointer page  108 of  134 
 
07:14:02.53   process pointer page  109 of  134 
 
07:14:02.61   process pointer page  110 of  134 
 
07:14:02.69   process pointer page  111 of  134 
 
07:14:02.76   process pointer page  112 of  134 
 
07:14:02.84   process pointer page  113 of  134 
 
07:14:02.92   process pointer page  114 of  134 
 
07:14:03.00   process pointer page  115 of  134 
 
07:14:03.07   process pointer page  116 of  134 
 
07:14:03.15   process pointer page  117 of  134 
 
07:14:03.23   process pointer page  118 of  134 
 
07:14:03.28   process pointer page  119 of  134 
 
07:14:03.31   process pointer page  120 of  134 
 
07:14:03.34   process pointer page  121 of  134 
 
07:14:03.39   process pointer page  122 of  134 
 
07:14:03.47   process pointer page  123 of  134 
 
07:14:03.55   process pointer page  124 of  134 
 
07:14:03.62   process pointer page  125 of  134 
 
07:14:03.70   process pointer page  126 of  134 
 
07:14:03.74   process pointer page  127 of  134 
 
07:14:03.77   process pointer page  128 of  134 
 
07:14:03.80   process pointer page  129 of  134 
 
07:14:03.83   process pointer page  130 of  134 
 
07:14:03.86   process pointer page  131 of  134 
 
07:14:03.89   process pointer page  132 of  134 
 
07:14:03.94   process pointer page  133 of  134 
 
07:14:03.99 Index 1 (PERF_LOG_DTS_BEG_DESC) 
 
07:14:07.10 Index 2 (PERF_LOG_UNIT) 
 
07:14:13.78 Index 3 (PERF_LOG_TRN_DESC) 
 
07:14:17.16 Index 4 (PERF_LOG_GDSCODE) 
 
07:14:19.03 Relation 162 (PERF_LOG) is ok 
 
 
07:14:19.03 Relation 166 (V_STOPTEST) 
 
07:14:19.03 Relation 166 (V_STOPTEST) is ok 
 
 
07:14:19.03 Relation 183 (V_QDISTR_SOURCE) 
 
07:14:19.03 Relation 183 (V_QDISTR_SOURCE) is ok 
 
 
07:14:19.03 Relation 184 (V_QSTORNED_SOURCE) 
 
07:14:19.03 Relation 184 (V_QSTORNED_SOURCE) is ok 
 
 
07:14:19.03 Relation 259 (XQD_1000_1200) 
 
07:14:19.04   process pointer page    0 of    5 
 
07:14:19.04   process pointer page    1 of    5 
 
07:14:19.04   process pointer page    2 of    5 
 
07:14:19.05   process pointer page    3 of    5 
 
07:14:19.05   process pointer page    4 of    5 
 
07:14:19.05 Index 1 (XQD_1000_1200_WARE_SOP_ROP_SND) 
 
07:14:19.06 Relation 259 (XQD_1000_1200) is ok 
 
 
07:14:19.06 Relation 260 (XQD_1200_2000) 
 
07:14:19.06   process pointer page    0 of    8 
 
07:14:19.09   process pointer page    1 of    8 
 
07:14:19.10   process pointer page    2 of    8 
 
07:14:19.11   process pointer page    3 of    8 
 
07:14:19.14   process pointer page    4 of    8 
 
07:14:19.17   process pointer page    5 of    8 
 
07:14:19.20   process pointer page    6 of    8 
 
07:14:19.20   process pointer page    7 of    8 
 
07:14:19.21 Index 1 (XQD_1200_2000_WARE_SOP_ROP_SND) 
 
07:14:19.23 Relation 260 (XQD_1200_2000) is ok 
 
 
07:14:19.23 Relation 261 (XQD_1000_3300) 
 
07:14:19.23   process pointer page    0 of   14 
 
07:14:19.32   process pointer page    1 of   14 
 
07:14:19.40   process pointer page    2 of   14 
 
07:14:19.44   process pointer page    3 of   14 
 
07:14:19.51   process pointer page    4 of   14 
 
07:14:19.60   process pointer page    5 of   14 
 
07:14:19.70   process pointer page    6 of   14 
 
07:14:19.81   process pointer page    7 of   14 
 
07:14:19.90   process pointer page    8 of   14 
 
07:14:19.99   process pointer page    9 of   14 
 
07:14:20.08   process pointer page   10 of   14 
 
07:14:20.17   process pointer page   11 of   14 
 
07:14:20.26   process pointer page   12 of   14 
 
07:14:20.34   process pointer page   13 of   14 
 
07:14:20.39 Index 1 (XQD_1000_3300_WARE_SOP_ROP_SND) 
 
07:14:20.92 Index 2 (XQD_1000_3300_DOC) 
 
07:14:21.34 Relation 261 (XQD_1000_3300) is ok 
 
 
07:14:21.34 Relation 262 (XQD_2000_3300) 
 
07:14:21.35   process pointer page    0 of   21 
 
07:14:21.44   process pointer page    1 of   21 
 
07:14:21.52   process pointer page    2 of   21 
 
07:14:21.58   process pointer page    3 of   21 
 
07:14:21.63   process pointer page    4 of   21 
 
07:14:21.73   process pointer page    5 of   21 
 
07:14:21.81   process pointer page    6 of   21 
 
07:14:21.89   process pointer page    7 of   21 
 
07:14:21.97   process pointer page    8 of   21 
 
07:14:22.00   process pointer page    9 of   21 
 
07:14:22.04   process pointer page   10 of   21 
 
07:14:22.07   process pointer page   11 of   21 
 
07:14:22.11   process pointer page   12 of   21 
 
07:14:22.19   process pointer page   13 of   21 
 
07:14:22.27   process pointer page   14 of   21 
 
07:14:22.36   process pointer page   15 of   21 
 
07:14:22.42   process pointer page   16 of   21 
 
07:14:22.45   process pointer page   17 of   21 
 
07:14:22.49   process pointer page   18 of   21 
 
07:14:22.52   process pointer page   19 of   21 
 
07:14:22.56   process pointer page   20 of   21 
 
07:14:22.56 Index 1 (XQD_2000_3300_WARE_SOP_ROP_SND) 
 
07:14:23.11 Relation 262 (XQD_2000_3300) is ok 
 
 
07:14:23.11 Relation 263 (XQD_2100_3300) 
 
07:14:23.11   process pointer page    0 of    6 
 
07:14:23.13   process pointer page    1 of    6 
 
07:14:23.14   process pointer page    2 of    6 
 
07:14:23.16   process pointer page    3 of    6 
 
07:14:23.17   process pointer page    4 of    6 
 
07:14:23.21   process pointer page    5 of    6 
 
07:14:23.24 Index 1 (XQD_2100_3300_WARE_SOP_ROP_SND) 
 
07:14:23.25 Relation 263 (XQD_2100_3300) is ok 
 
 
07:14:23.25 Relation 264 (XQD_3300_3400) 
 
07:14:23.25   process pointer page    0 of   22 
 
07:14:23.34   process pointer page    1 of   22 
 
07:14:23.44   process pointer page    2 of   22 
 
07:14:23.52   process pointer page    3 of   22 
 
07:14:23.56   process pointer page    4 of   22 
 
07:14:23.59   process pointer page    5 of   22 
 
07:14:23.66   process pointer page    6 of   22 
 
07:14:23.75   process pointer page    7 of   22 
 
07:14:23.85   process pointer page    8 of   22 
 
07:14:23.94   process pointer page    9 of   22 
 
07:14:24.03   process pointer page   10 of   22 
 
07:14:24.12   process pointer page   11 of   22 
 
07:14:24.21   process pointer page   12 of   22 
 
07:14:24.30   process pointer page   13 of   22 
 
07:14:24.40   process pointer page   14 of   22 
 
07:14:24.47   process pointer page   15 of   22 
 
07:14:24.51   process pointer page   16 of   22 
 
07:14:24.60   process pointer page   17 of   22 
 
07:14:24.69   process pointer page   18 of   22 
 
07:14:24.78   process pointer page   19 of   22 
 
07:14:24.83   process pointer page   20 of   22 
 
07:14:24.87   process pointer page   21 of   22 
 
07:14:24.88 Index 1 (XQD_3300_3400_WARE_SOP_ROP_SND) 
 
07:14:25.63 Relation 264 (XQD_3300_3400) is ok 
 
 
07:14:25.63 Relation 265 (XQS_1000_1200) 
 
07:14:25.63   process pointer page    0 of   37 
 
07:14:25.67   process pointer page    1 of   37 
 
07:14:25.70   process pointer page    2 of   37 
 
07:14:25.73   process pointer page    3 of   37 
 
07:14:25.76   process pointer page    4 of   37 
 
07:14:25.80   process pointer page    5 of   37 
 
07:14:25.88   process pointer page    6 of   37 
 
07:14:25.97   process pointer page    7 of   37 
 
07:14:26.06   process pointer page    8 of   37 
 
07:14:26.15   process pointer page    9 of   37 
 
07:14:26.24   process pointer page   10 of   37 
 
07:14:26.34   process pointer page   11 of   37 
 
07:14:26.43   process pointer page   12 of   37 
 
07:14:26.52   process pointer page   13 of   37 
 
07:14:26.61   process pointer page   14 of   37 
 
07:14:26.68   process pointer page   15 of   37 
 
07:14:26.72   process pointer page   16 of   37 
 
07:14:26.81   process pointer page   17 of   37 
 
07:14:26.90   process pointer page   18 of   37 
 
07:14:26.99   process pointer page   19 of   37 
 
07:14:27.04   process pointer page   20 of   37 
 
07:14:27.10   process pointer page   21 of   37 
 
07:14:27.18   process pointer page   22 of   37 
 
07:14:27.27   process pointer page   23 of   37 
 
07:14:27.36   process pointer page   24 of   37 
 
07:14:27.46   process pointer page   25 of   37 
 
07:14:27.55   process pointer page   26 of   37 
 
07:14:27.64   process pointer page   27 of   37 
 
07:14:27.73   process pointer page   28 of   37 
 
07:14:27.82   process pointer page   29 of   37 
 
07:14:27.91   process pointer page   30 of   37 
 
07:14:28.00   process pointer page   31 of   37 
 
07:14:28.09   process pointer page   32 of   37 
 
07:14:28.18   process pointer page   33 of   37 
 
07:14:28.26   process pointer page   34 of   37 
 
07:14:28.36   process pointer page   35 of   37 
 
07:14:28.45   process pointer page   36 of   37 
 
07:14:28.47 Index 1 (XQS_1000_1200_DOC_ID) 
 
07:14:29.46 Index 2 (XQS_1000_1200_SND_ID) 
 
07:14:30.40 Index 3 (XQS_1000_1200_RCV_ID) 
 
07:14:31.25 Relation 265 (XQS_1000_1200) is ok 
 
 
07:14:31.25 Relation 266 (XQS_1200_2000) 
 
07:14:31.25   process pointer page    0 of   43 
 
07:14:31.33   process pointer page    1 of   43 
 
07:14:31.42   process pointer page    2 of   43 
 
07:14:31.51   process pointer page    3 of   43 
 
07:14:31.60   process pointer page    4 of   43 
 
07:14:31.69   process pointer page    5 of   43 
 
07:14:31.77   process pointer page    6 of   43 
 
07:14:31.80   process pointer page    7 of   43 
 
07:14:31.89   process pointer page    8 of   43 
 
07:14:31.98   process pointer page    9 of   43 
 
07:14:32.08   process pointer page   10 of   43 
 
07:14:32.16   process pointer page   11 of   43 
 
07:14:32.20   process pointer page   12 of   43 
 
07:14:32.24   process pointer page   13 of   43 
 
07:14:32.27   process pointer page   14 of   43 
 
07:14:32.32   process pointer page   15 of   43 
 
07:14:32.41   process pointer page   16 of   43 
 
07:14:32.50   process pointer page   17 of   43 
 
07:14:32.57   process pointer page   18 of   43 
 
07:14:32.61   process pointer page   19 of   43 
 
07:14:32.64   process pointer page   20 of   43 
 
07:14:32.68   process pointer page   21 of   43 
 
07:14:32.71   process pointer page   22 of   43 
 
07:14:32.75   process pointer page   23 of   43 
 
07:14:32.83   process pointer page   24 of   43 
 
07:14:32.93   process pointer page   25 of   43 
 
07:14:33.02   process pointer page   26 of   43 
 
07:14:33.12   process pointer page   27 of   43 
 
07:14:33.21   process pointer page   28 of   43 
 
07:14:33.30   process pointer page   29 of   43 
 
07:14:33.39   process pointer page   30 of   43 
 
07:14:33.47   process pointer page   31 of   43 
 
07:14:33.50   process pointer page   32 of   43 
 
07:14:33.59   process pointer page   33 of   43 
 
07:14:33.68   process pointer page   34 of   43 
 
07:14:33.77   process pointer page   35 of   43 
 
07:14:33.80   process pointer page   36 of   43 
 
07:14:33.89   process pointer page   37 of   43 
 
07:14:33.99   process pointer page   38 of   43 
 
07:14:34.09   process pointer page   39 of   43 
 
07:14:34.17   process pointer page   40 of   43 
 
07:14:34.20   process pointer page   41 of   43 
 
07:14:34.24   process pointer page   42 of   43 
 
07:14:34.29 Index 1 (XQS_1200_2000_DOC_ID) 
 
07:14:35.52 Index 2 (XQS_1200_2000_SND_ID) 
 
07:14:36.98 Index 3 (XQS_1200_2000_RCV_ID) 
 
07:14:38.23 Relation 266 (XQS_1200_2000) is ok 
 
 
07:14:38.23 Relation 267 (XQS_1000_3300) 
 
07:14:38.23   process pointer page    0 of   16 
 
07:14:38.34   process pointer page    1 of   16 
 
07:14:38.45   process pointer page    2 of   16 
 
07:14:38.56   process pointer page    3 of   16 
 
07:14:38.67   process pointer page    4 of   16 
 
07:14:38.78   process pointer page    5 of   16 
 
07:14:38.87   process pointer page    6 of   16 
 
07:14:38.92   process pointer page    7 of   16 
 
07:14:39.03   process pointer page    8 of   16 
 
07:14:39.14   process pointer page    9 of   16 
 
07:14:39.24   process pointer page   10 of   16 
 
07:14:39.29   process pointer page   11 of   16 
 
07:14:39.33   process pointer page   12 of   16 
 
07:14:39.38   process pointer page   13 of   16 
 
07:14:39.42   process pointer page   14 of   16 
 
07:14:39.46   process pointer page   15 of   16 
 
07:14:39.55 Index 1 (XQS_1000_3300_DOC_ID) 
 
07:14:40.09 Index 2 (XQS_1000_3300_SND_ID) 
 
07:14:40.60 Index 3 (XQS_1000_3300_RCV_ID) 
 
07:14:41.07 Relation 267 (XQS_1000_3300) is ok 
 
 
07:14:41.07 Relation 268 (XQS_2000_3300) 
 
07:14:41.07   process pointer page    0 of    1 
 
07:14:41.07 Index 1 (XQS_2000_3300_DOC_ID) 
 
07:14:41.08 Index 2 (XQS_2000_3300_SND_ID) 
 
07:14:41.08 Index 3 (XQS_2000_3300_RCV_ID) 
 
07:14:41.08 Relation 268 (XQS_2000_3300) is ok 
 
 
07:14:41.08 Relation 269 (XQS_2100_3300) 
 
07:14:41.08   process pointer page    0 of   28 
 
07:14:41.18   process pointer page    1 of   28 
 
07:14:41.29   process pointer page    2 of   28 
 
07:14:41.40   process pointer page    3 of   28 
 
07:14:41.50   process pointer page    4 of   28 
 
07:14:41.61   process pointer page    5 of   28 
 
07:14:41.71   process pointer page    6 of   28 
 
07:14:41.81   process pointer page    7 of   28 
 
07:14:41.85   process pointer page    8 of   28 
 
07:14:41.89   process pointer page    9 of   28 
 
07:14:41.97   process pointer page   10 of   28 
 
07:14:42.08   process pointer page   11 of   28 
 
07:14:42.19   process pointer page   12 of   28 
 
07:14:42.30   process pointer page   13 of   28 
 
07:14:42.40   process pointer page   14 of   28 
 
07:14:42.50   process pointer page   15 of   28 
 
07:14:42.61   process pointer page   16 of   28 
 
07:14:42.72   process pointer page   17 of   28 
 
07:14:42.78   process pointer page   18 of   28 
 
07:14:42.82   process pointer page   19 of   28 
 
07:14:42.86   process pointer page   20 of   28 
 
07:14:42.90   process pointer page   21 of   28 
 
07:14:42.94   process pointer page   22 of   28 
 
07:14:42.97   process pointer page   23 of   28 
 
07:14:43.01   process pointer page   24 of   28 
 
07:14:43.04   process pointer page   25 of   28 
 
07:14:43.11   process pointer page   26 of   28 
 
07:14:43.21   process pointer page   27 of   28 
 
07:14:43.27 Index 1 (XQS_2100_3300_DOC_ID) 
 
07:14:43.96 Index 2 (XQS_2100_3300_SND_ID) 
 
07:14:44.81 Index 3 (XQS_2100_3300_RCV_ID) 
 
07:14:45.48 Relation 269 (XQS_2100_3300) is ok 
 
 
07:14:45.48 Relation 270 (XQS_3300_3400) 
 
07:14:45.48   process pointer page    0 of    5 
 
07:14:45.54   process pointer page    1 of    5 
 
07:14:45.62   process pointer page    2 of    5 
 
07:14:45.66   process pointer page    3 of    5 
 
07:14:45.70   process pointer page    4 of    5 
 
07:14:45.71 Index 1 (XQS_3300_3400_DOC_ID) 
 
07:14:45.77 Index 2 (XQS_3300_3400_SND_ID) 
 
07:14:45.82 Relation 270 (XQS_3300_3400) is ok 
 
 
07:14:45.82 Relation 276 (TRACE_STAT) 
 
07:14:45.82   process pointer page    0 of    1 
 
07:14:45.82 Relation 276 (TRACE_STAT) is ok 
 
 
07:14:45.82 Validation finished 
 
Done for 54620 ms, from  7:13:51.20 to  7:14:45.82. 
 
 Differences between old and current firebird.log 
7:14:46.73. Got:
 
STDOUT: ---------- E:\TEMP\LOGS.OLTP30\OLTP30_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:
 
2016-11-27  07:14               504 oltp30_fb_log_when_test_finished.log 
 
End of gathering firebird.log AFTER test finish. 
+++ Start of comparison +++
 
Comparing files E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log and E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
***** E:\TEMP\LOGS.OLTP30\oltp30_fb_log_when_test_started.log 
 
***** E:\TEMP\LOGS.OLTP30\OLTP30_FB_LOG_WHEN_TEST_FINISHED.LOG 
 
5:   
 
6:  WIN-2BE1UI8LGDL Sun Nov 27 07:13:51 2016 
 
7:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
8:          Validation started 
 
9:   
 
10:   
 
11:  WIN-2BE1UI8LGDL Sun Nov 27 07:14:45 2016 
 
12:          Database: D:\OLTP-EMUL\OLTP30-SMALL.FDB 
 
13:          Validation finished: 0 errors, 0 warnings, 0 fixed 
 
14:   
 
***** 
 
+++ End of comparison +++ 
 
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.oltp30\oltp30_*.*: 
 
 
| ERRORS_CHECKING_RESULT | 
| NO_SEVERE_ERRORS_FOUND | 
 
ISQL logs are removed because no severe errors occured during test. 
 
2016-11-27  7:14:54.39 - end of report, text file: e:\temp\logs.oltp30\oltp30.report.txt, html: e:\temp\logs.oltp30\oltp30.report.html