The CREATE DATABASE process is allocating 0.75 MB on disk 'listtest'. The CREATE DATABASE process is allocating 0.49 MB on disk 'listtest_log'. Bulk-loaded 202985 rows into usrdictwords. Strsize Data Optype Method Cnt Avg Min Max Stdev Varcoeff ------- ---- ------ ------ --- --- --- --- ----- -------- 237 Int UNPACK FIX$SINGLE 100 2 0 16 6 2.8359 237 Int UNPACK FIX$MULTI 100 3 0 16 6 2.1130 237 Int UNPACK TBLNUM$IL 100 4 0 16 7 1.7489 237 Int UNPACK FIX$ITER 100 5 0 16 7 1.4530 237 Int UNPACK ITER 100 5 0 16 7 1.4453 237 Int UNPACK TBLNUM 100 5 0 16 7 1.4245 237 Int UNPACK XMLATTR 100 5 0 16 8 1.5016 237 Int UNPACK XMLELEM 100 5 0 16 7 1.4607 237 Int UNPACK ITER$PROC 100 9 0 16 7 0.8113 237 Int UNPACK UNION 100 9 0 16 7 0.8234 237 Int UNPACK INSERT 100 15 0 33 4 0.2521 237 Int JOIN FIX$MULTI 100 3 0 16 7 2.2589 237 Int JOIN FIX$SINGLE 100 3 0 16 6 2.0071 237 Int JOIN TBLNUM$IL 100 3 0 16 7 2.1943 237 Int JOIN ITER 100 4 0 16 7 1.7380 237 Int JOIN FIX$ITER 100 5 0 16 7 1.4757 237 Int JOIN TBLNUM 100 5 0 30 8 1.5379 237 Int JOIN XMLELEM 100 5 0 16 7 1.4684 237 Int JOIN EXEC$B 100 6 0 16 8 1.2605 237 Int JOIN XMLATTR 100 6 0 16 7 1.2374 237 Int JOIN EXEC$A 100 8 0 16 8 0.9477 237 Int JOIN ITER$PROC 100 10 0 16 7 0.7089 237 Int JOIN UNION 100 11 0 16 7 0.6003 237 Int JOIN INSERT 100 15 0 30 4 0.2978 237 Int JOIN REALSLOW 2 14414 13546 15283 1228 0.0852 237 Int JOIN SLOW$LIKE 2 15046 13576 16516 2079 0.1381 237 Str UNPACK FIX$MULTI 100 2 0 16 5 2.7380 237 Str UNPACK FIX$SINGLE 100 2 0 16 6 2.7558 237 Str UNPACK TBLNUM$IL 100 3 0 30 7 2.3417 237 Str UNPACK XMLATTR 100 4 0 16 7 1.7939 237 Str UNPACK FIX$ITER 100 5 0 16 7 1.4741 237 Str UNPACK ITER 100 6 0 16 8 1.2550 237 Str UNPACK XMLELEM 100 6 0 16 8 1.2540 237 Str UNPACK ITER$PROC 100 7 0 16 8 1.0992 237 Str UNPACK TBLNUM 100 7 0 16 8 1.0892 237 Str UNPACK UNION 100 11 0 30 7 0.6186 237 Str UNPACK INSERT 100 17 13 33 6 0.3684 237 Str UNPACK ITER$EXEC 100 28 13 33 6 0.2279 237 Str JOIN EXEC$B 100 4 0 16 7 1.7939 237 Str JOIN FIX$MULTI 100 5 0 16 7 1.4639 237 Str JOIN FIX$SINGLE 100 5 0 16 7 1.4245 237 Str JOIN TBLNUM$IL 100 6 0 30 8 1.3109 237 Str JOIN FIX$ITER 100 7 0 16 8 1.0716 237 Str JOIN ITER 100 7 0 16 8 1.0851 237 Str JOIN XMLATTR 100 7 0 16 8 1.1015 237 Str JOIN XMLELEM 100 7 0 16 8 1.1094 237 Str JOIN TBLNUM 100 8 0 16 8 0.9498 237 Str JOIN ITER$PROC 100 10 0 33 8 0.7743 237 Str JOIN UNION 100 12 0 30 6 0.5290 237 Str JOIN INSERT 100 19 13 33 8 0.4052 237 Str JOIN ITER$EXEC 100 30 13 50 6 0.1975 237 Str JOIN EXEC$A 100 39 30 60 8 0.2048 237 Str JOIN SLOW$LIKE 2 21135 21080 21190 78 0.0036 237 Str JOIN REALSLOW 2 21485 21030 21940 643 0.0299 2456 Int UNPACK FIX$SINGLE 100 3 0 16 7 2.1777 2456 Int UNPACK FIX$MULTI 100 6 0 16 7 1.2201 2456 Int UNPACK TBLNUM$IL 100 9 0 16 7 0.8101 2456 Int UNPACK TBLNUM 100 13 0 16 5 0.4061 2456 Int UNPACK FIX$ITER 100 20 13 33 8 0.3820 2456 Int UNPACK ITER 100 22 13 33 8 0.3615 2456 Int UNPACK XMLATTR 100 23 13 33 8 0.3514 2456 Int UNPACK XMLELEM 100 24 13 33 8 0.3499 2456 Int UNPACK ITER$PROC 100 32 30 46 5 0.1468 2456 Int UNPACK UNION 100 96 90 110 6 0.0665 2456 Int UNPACK INSERT 100 130 123 233 13 0.0998 2456 Int JOIN FIX$SINGLE 100 7 0 16 8 1.1016 2456 Int JOIN FIX$MULTI 100 11 0 33 7 0.6686 2456 Int JOIN TBLNUM$IL 100 13 0 33 6 0.4830 2456 Int JOIN TBLNUM 100 16 13 33 4 0.2707 2456 Int JOIN FIX$ITER 100 24 13 33 8 0.3303 2456 Int JOIN XMLATTR 100 26 13 33 7 0.2740 2456 Int JOIN XMLELEM 100 26 13 33 7 0.2826 2456 Int JOIN ITER 100 27 13 33 7 0.2670 2456 Int JOIN ITER$PROC 100 37 30 50 7 0.1969 2456 Int JOIN EXEC$A 100 96 76 110 9 0.0928 2456 Int JOIN EXEC$B 100 96 63 110 10 0.1068 2456 Int JOIN UNION 100 101 90 110 8 0.0796 2456 Int JOIN INSERT 100 133 123 143 8 0.0603 2456 Int JOIN SLOW$LIKE 2 128233 126513 129953 2432 0.0189 2456 Int JOIN REALSLOW 2 129413 126843 131983 3635 0.0280 2456 Str UNPACK FIX$MULTI 100 5 0 16 7 1.4859 2456 Str UNPACK FIX$SINGLE 100 5 0 16 7 1.4639 2456 Str UNPACK TBLNUM$IL 100 12 0 30 6 0.4910 2456 Str UNPACK TBLNUM 100 15 13 33 4 0.2447 2456 Str UNPACK FIX$ITER 100 20 13 33 8 0.3769 2456 Str UNPACK ITER 100 22 13 33 8 0.3761 2456 Str UNPACK ITER$PROC 100 23 13 46 8 0.3659 2456 Str UNPACK XMLATTR 100 23 13 46 9 0.3698 2456 Str UNPACK XMLELEM 100 24 13 33 8 0.3306 2456 Str UNPACK UNION 100 119 106 140 8 0.0674 2456 Str UNPACK INSERT 100 164 153 216 10 0.0608 2456 Str UNPACK ITER$EXEC 100 247 233 266 8 0.0333 2456 Str JOIN EXEC$B 100 17 13 33 6 0.3340 2456 Str JOIN FIX$SINGLE 100 18 13 33 6 0.3544 2456 Str JOIN FIX$MULTI 100 19 13 33 8 0.3957 2456 Str JOIN TBLNUM$IL 100 27 13 60 8 0.3026 2456 Str JOIN TBLNUM 100 28 13 33 6 0.2090 2456 Str JOIN FIX$ITER 100 32 30 46 4 0.1194 2456 Str JOIN XMLELEM 100 34 30 46 7 0.1927 2456 Str JOIN ITER 100 35 30 50 7 0.2027 2456 Str JOIN XMLATTR 100 35 30 50 7 0.1987 2456 Str JOIN ITER$PROC 100 37 30 50 8 0.2076 2456 Str JOIN UNION 100 135 123 170 8 0.0610 2456 Str JOIN INSERT 100 178 170 190 8 0.0435 2456 Str JOIN EXEC$A 100 219 203 236 8 0.0355 2456 Str JOIN ITER$EXEC 100 261 250 296 9 0.0344 2456 Str JOIN SLOW$LIKE 2 202983 201750 204216 1744 0.0085 2456 Str JOIN REALSLOW 2 203429 202953 203906 674 0.0033 7950 Int UNPACK FIX$SINGLE 100 8 0 16 8 0.9539 7950 Int UNPACK FIX$MULTI 100 17 13 33 7 0.3894 7950 Int UNPACK TBLNUM$IL 100 28 13 46 6 0.2267 7950 Int UNPACK TBLNUM 100 34 30 50 6 0.1829 7950 Int UNPACK FIX$ITER 100 58 43 63 7 0.1165 7950 Int UNPACK ITER 100 65 60 80 7 0.1009 7950 Int UNPACK XMLELEM 100 89 76 96 7 0.0788 7950 Int UNPACK ITER$PROC 100 91 76 96 6 0.0632 7950 Int UNPACK XMLATTR 100 92 76 580 53 0.5766 7950 Int JOIN EXEC$B 100 18 13 33 7 0.3640 7950 Int JOIN FIX$SINGLE 100 19 13 33 7 0.3836 7950 Int JOIN FIX$MULTI 100 30 13 46 6 0.1867 7950 Int JOIN TBLNUM$IL 100 42 30 63 8 0.1835 7950 Int JOIN TBLNUM 100 45 30 50 3 0.0767 7950 Int JOIN FIX$ITER 100 70 60 80 8 0.1162 7950 Int JOIN ITER 100 75 60 80 6 0.0783 7950 Int JOIN XMLATTR 100 99 90 110 8 0.0799 7950 Int JOIN XMLELEM 100 102 90 110 8 0.0778 7950 Int JOIN ITER$PROC 100 261 96 283 18 0.0688 7950 Int JOIN EXEC$A 100 737 643 826 37 0.0504 7950 Str UNPACK FIX$SINGLE 100 6 0 16 8 1.2550 7950 Str UNPACK FIX$MULTI 100 17 13 33 6 0.3314 7950 Str UNPACK TBLNUM 100 42 30 50 7 0.1574 7950 Str UNPACK TBLNUM$IL 100 42 30 76 8 0.1883 7950 Str UNPACK FIX$ITER 100 59 43 63 7 0.1117 7950 Str UNPACK ITER$PROC 100 62 46 80 5 0.0753 7950 Str UNPACK ITER 100 67 60 80 8 0.1187 7950 Str UNPACK XMLATTR 100 89 76 280 21 0.2315 7950 Str UNPACK XMLELEM 100 107 76 1736 165 1.5381 7950 Str UNPACK ITER$EXEC 100 796 763 830 12 0.0156 7950 Str JOIN FIX$SINGLE 100 48 46 63 6 0.1190 7950 Str JOIN FIX$MULTI 100 57 46 63 7 0.1292 7950 Str JOIN TBLNUM 100 78 63 93 6 0.0710 7950 Str JOIN TBLNUM$IL 100 85 76 110 8 0.0992 7950 Str JOIN FIX$ITER 100 96 76 156 9 0.0899 7950 Str JOIN ITER 100 103 93 126 8 0.0799 7950 Str JOIN ITER$PROC 100 106 93 123 7 0.0686 7950 Str JOIN XMLELEM 100 130 123 143 8 0.0627 7950 Str JOIN XMLATTR 100 131 123 343 23 0.1732 7950 Str JOIN EXEC$B 100 358 343 376 7 0.0193 7950 Str JOIN ITER$EXEC 100 841 796 890 15 0.0175 7950 Str JOIN EXEC$A 100 1450 1343 1720 44 0.0306 23997 Int UNPACK FIX$SINGLE 100 15 13 33 4 0.2411 23997 Int UNPACK FIX$MULTI 100 44 30 63 6 0.1295 23997 Int UNPACK TBLNUM 100 93 76 123 7 0.0726 23997 Int UNPACK FIX$ITER 100 166 153 250 12 0.0694 23997 Int UNPACK ITER 100 187 170 233 9 0.0468 23997 Int UNPACK ITER$PROC 100 261 250 310 11 0.0438 23997 Int UNPACK XMLELEM 100 281 263 376 14 0.0497 23997 Int UNPACK XMLATTR 100 283 263 640 39 0.1387 23997 Int JOIN EXEC$B 100 48 46 63 6 0.1189 23997 Int JOIN FIX$SINGLE 100 52 43 63 8 0.1500 23997 Int JOIN FIX$MULTI 100 80 76 126 8 0.1035 23997 Int JOIN TBLNUM 100 128 123 156 8 0.0606 23997 Int JOIN FIX$ITER 100 201 186 280 11 0.0553 23997 Int JOIN ITER 100 221 203 266 9 0.0401 23997 Int JOIN XMLATTR 100 307 293 343 11 0.0361 23997 Int JOIN XMLELEM 100 317 296 530 24 0.0764 23997 Int JOIN ITER$PROC 100 445 423 500 14 0.0307 23997 Int JOIN EXEC$A 100 7430 6580 8156 300 0.0403 23997 Str UNPACK FIX$SINGLE 100 16 13 110 10 0.6363 23997 Str UNPACK FIX$MULTI 100 46 30 110 9 0.2047 23997 Str UNPACK TBLNUM 100 118 106 140 8 0.0708 23997 Str UNPACK FIX$ITER 100 168 153 403 25 0.1494 23997 Str UNPACK ITER$PROC 100 168 153 203 8 0.0493 23997 Str UNPACK ITER 100 200 186 250 8 0.0408 23997 Str UNPACK XMLATTR 100 293 263 796 57 0.1952 23997 Str UNPACK XMLELEM 100 304 280 893 71 0.2343 23997 Str UNPACK ITER$EXEC 100 2407 2343 2543 31 0.0126 23997 Str JOIN FIX$SINGLE 100 144 140 170 7 0.0474 23997 Str JOIN FIX$MULTI 100 170 153 220 9 0.0544 23997 Str JOIN TBLNUM 100 226 216 266 9 0.0381 23997 Str JOIN FIX$ITER 100 280 263 393 14 0.0486 23997 Str JOIN ITER$PROC 100 304 293 326 9 0.0287 23997 Str JOIN ITER 100 309 296 330 9 0.0279 23997 Str JOIN EXEC$B 100 386 373 423 10 0.0249 23997 Str JOIN XMLATTR 100 414 390 546 19 0.0464 23997 Str JOIN XMLELEM 100 420 403 466 14 0.0324 23997 Str JOIN ITER$EXEC 100 2539 2470 2656 32 0.0125 23997 Str JOIN EXEC$A 100 11821 11360 12983 251 0.0212 120000 Int UNPACK FIX$MULTI 100 207 200 250 8 0.0404 120000 Int UNPACK TBLNUM 100 443 436 470 9 0.0194 120000 Int UNPACK FIX$ITER 100 793 780 830 9 0.0110 120000 Int UNPACK ITER 100 903 873 1106 26 0.0286 120000 Int UNPACK ITER$PROC 100 1253 1220 1330 20 0.0159 120000 Int UNPACK XMLELEM 100 1471 1450 1966 52 0.0351 120000 Int UNPACK XMLATTR 100 1473 1440 1580 20 0.0132 120000 Int JOIN FIX$MULTI 100 387 373 406 7 0.0191 120000 Int JOIN TBLNUM 100 616 606 626 8 0.0126 120000 Int JOIN FIX$ITER 100 965 950 986 9 0.0092 120000 Int JOIN ITER 100 1070 1046 1173 18 0.0171 120000 Int JOIN ITER$PROC 100 1485 1436 1653 25 0.0168 120000 Int JOIN XMLATTR 100 1655 1623 1733 19 0.0114 120000 Int JOIN XMLELEM 100 1684 1626 3093 152 0.0902 120000 Str UNPACK FIX$MULTI 100 207 200 326 14 0.0694 120000 Str UNPACK TBLNUM 100 572 560 640 11 0.0188 120000 Str UNPACK FIX$ITER 100 797 780 843 10 0.0121 120000 Str UNPACK ITER$PROC 100 801 793 830 8 0.0105 120000 Str UNPACK ITER 100 969 940 1076 20 0.0209 120000 Str UNPACK XMLATTR 100 1497 1466 1856 40 0.0267 120000 Str UNPACK XMLELEM 100 1568 1513 3513 203 0.1291 120000 Str JOIN FIX$MULTI 100 767 750 796 8 0.0109 120000 Str JOIN TBLNUM 100 1100 1090 1140 9 0.0084 120000 Str JOIN ITER$PROC 100 1318 1293 1423 16 0.0122 120000 Str JOIN FIX$ITER 100 1360 1340 1423 14 0.0104 120000 Str JOIN ITER 100 1506 1483 1720 27 0.0179 120000 Str JOIN XMLATTR 100 2148 2076 3610 153 0.0713 120000 Str JOIN XMLELEM 100 2162 2093 2673 66 0.0304 Tool completed successfully