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$MULTI 100 46 30 63 10 0.2269 237 Int UNPACK FIX$SINGLE 100 47 30 106 13 0.2695 237 Int UNPACK FIX$ITER 100 48 30 156 16 0.3257 237 Int UNPACK TBLNUM$IL 100 49 30 126 17 0.3428 237 Int UNPACK ITER 100 50 30 140 16 0.3135 237 Int UNPACK XMLATTR 100 51 30 156 18 0.3508 237 Int UNPACK XMLELEM 100 51 30 123 12 0.2326 237 Int UNPACK TBLNUM 100 52 30 140 17 0.3181 237 Int UNPACK ITER$PROC 100 60 30 140 14 0.2409 237 Int UNPACK UNION 100 61 30 140 16 0.2649 237 Int UNPACK INSERT 100 78 60 126 14 0.1777 237 Int JOIN FIX$SINGLE 100 47 30 93 13 0.2806 237 Int JOIN TBLNUM$IL 100 50 30 140 16 0.3290 237 Int JOIN ITER 100 51 30 156 18 0.3495 237 Int JOIN XMLELEM 100 51 30 156 14 0.2794 237 Int JOIN FIX$ITER 100 53 30 123 15 0.2907 237 Int JOIN TBLNUM 100 53 30 156 20 0.3698 237 Int JOIN XMLATTR 100 53 30 143 16 0.2990 237 Int JOIN ITER$PROC 100 62 43 110 12 0.1901 237 Int JOIN UNION 100 66 30 233 28 0.4238 237 Int JOIN FIX$MULTI 100 67 30 233 29 0.4373 237 Int JOIN EXEC$B 100 68 30 170 24 0.3541 237 Int JOIN EXEC$A 100 70 46 173 18 0.2637 237 Int JOIN INSERT 100 80 60 200 17 0.2091 237 Int JOIN REALSLOW 2 7624 7153 8096 667 0.0874 237 Int JOIN SLOW$LIKE 2 7640 7170 8110 665 0.0870 237 Str UNPACK FIX$SINGLE 100 47 30 106 13 0.2829 237 Str UNPACK FIX$MULTI 100 49 30 80 13 0.2631 237 Str UNPACK FIX$ITER 100 50 30 123 12 0.2414 237 Str UNPACK TBLNUM 100 50 30 110 11 0.2111 237 Str UNPACK TBLNUM$IL 100 50 30 126 14 0.2773 237 Str UNPACK XMLATTR 100 50 30 110 11 0.2110 237 Str UNPACK ITER 100 51 30 126 16 0.3208 237 Str UNPACK XMLELEM 100 54 30 156 18 0.3276 237 Str UNPACK ITER$PROC 100 58 33 140 16 0.2729 237 Str UNPACK UNION 100 62 46 126 13 0.2150 237 Str UNPACK INSERT 100 82 60 266 24 0.2926 237 Str UNPACK ITER$EXEC 100 88 60 220 20 0.2264 237 Str JOIN EXEC$B 100 51 30 123 17 0.3365 237 Str JOIN FIX$ITER 100 51 30 93 10 0.1873 237 Str JOIN ITER 100 51 33 93 9 0.1752 237 Str JOIN FIX$SINGLE 100 52 30 156 20 0.3757 237 Str JOIN TBLNUM 100 53 30 140 13 0.2422 237 Str JOIN XMLELEM 100 54 30 126 15 0.2711 237 Str JOIN XMLATTR 100 57 43 233 23 0.3968 237 Str JOIN TBLNUM$IL 100 58 30 170 19 0.3298 237 Str JOIN ITER$PROC 100 64 46 156 17 0.2585 237 Str JOIN FIX$MULTI 100 65 43 250 29 0.4422 237 Str JOIN UNION 100 67 43 156 17 0.2567 237 Str JOIN INSERT 100 85 60 126 13 0.1504 237 Str JOIN ITER$EXEC 100 89 60 140 16 0.1809 237 Str JOIN EXEC$A 100 115 90 280 20 0.1734 237 Str JOIN SLOW$LIKE 2 10843 10826 10860 24 0.0022 237 Str JOIN REALSLOW 2 42233 42140 42326 132 0.0031 2456 Int UNPACK FIX$SINGLE 100 47 13 76 11 0.2258 2456 Int UNPACK FIX$MULTI 100 54 30 93 12 0.2312 2456 Int UNPACK TBLNUM$IL 100 58 30 110 12 0.2068 2456 Int UNPACK TBLNUM 100 66 43 203 19 0.2885 2456 Int UNPACK FIX$ITER 100 83 60 173 14 0.1663 2456 Int UNPACK ITER 100 83 60 96 9 0.1025 2456 Int UNPACK XMLATTR 100 93 76 123 10 0.1032 2456 Int UNPACK XMLELEM 100 93 76 173 12 0.1258 2456 Int UNPACK ITER$PROC 100 110 93 140 11 0.0999 2456 Int UNPACK UNION 100 209 186 263 13 0.0611 2456 Int UNPACK INSERT 100 346 313 390 13 0.0374 2456 Int JOIN EXEC$B 100 54 30 123 14 0.2624 2456 Int JOIN FIX$SINGLE 100 55 30 93 13 0.2376 2456 Int JOIN TBLNUM$IL 100 67 46 143 13 0.1919 2456 Int JOIN TBLNUM 100 75 60 110 10 0.1306 2456 Int JOIN FIX$MULTI 100 81 60 326 41 0.5093 2456 Int JOIN FIX$ITER 100 92 76 126 11 0.1154 2456 Int JOIN ITER 100 94 76 156 11 0.1189 2456 Int JOIN XMLATTR 100 102 80 153 11 0.1125 2456 Int JOIN XMLELEM 100 103 76 173 16 0.1505 2456 Int JOIN ITER$PROC 100 119 93 186 15 0.1231 2456 Int JOIN UNION 100 219 186 250 12 0.0560 2456 Int JOIN EXEC$A 100 249 200 330 21 0.0858 2456 Int JOIN INSERT 100 356 330 406 14 0.0395 2456 Int JOIN REALSLOW 2 67823 67150 68496 952 0.0140 2456 Int JOIN SLOW$LIKE 2 68166 67433 68900 1037 0.0152 2456 Str UNPACK FIX$SINGLE 100 46 30 80 11 0.2432 2456 Str UNPACK FIX$MULTI 100 53 30 80 10 0.1905 2456 Str UNPACK TBLNUM$IL 100 62 46 106 12 0.1933 2456 Str UNPACK TBLNUM 100 75 60 173 21 0.2765 2456 Str UNPACK FIX$ITER 100 86 60 173 16 0.1918 2456 Str UNPACK ITER 100 88 76 170 13 0.1521 2456 Str UNPACK ITER$PROC 100 89 63 123 10 0.1179 2456 Str UNPACK XMLELEM 100 94 76 173 13 0.1433 2456 Str UNPACK XMLATTR 100 96 76 190 15 0.1512 2456 Str UNPACK UNION 100 242 216 283 12 0.0514 2456 Str UNPACK INSERT 100 387 356 440 16 0.0420 2456 Str UNPACK ITER$EXEC 100 414 376 560 22 0.0520 2456 Str JOIN EXEC$B 100 73 46 126 13 0.1770 2456 Str JOIN FIX$SINGLE 100 76 60 123 11 0.1492 2456 Str JOIN TBLNUM$IL 100 97 76 156 14 0.1407 2456 Str JOIN TBLNUM 100 100 76 206 17 0.1701 2456 Str JOIN FIX$MULTI 100 101 76 373 30 0.3004 2456 Str JOIN FIX$ITER 100 114 93 203 16 0.1395 2456 Str JOIN ITER 100 116 93 170 13 0.1137 2456 Str JOIN XMLATTR 100 122 93 186 14 0.1127 2456 Str JOIN ITER$PROC 100 123 106 143 10 0.0793 2456 Str JOIN XMLELEM 100 125 106 220 17 0.1396 2456 Str JOIN UNION 100 277 250 343 14 0.0488 2456 Str JOIN INSERT 100 420 390 500 18 0.0417 2456 Str JOIN ITER$EXEC 100 443 406 513 16 0.0368 2456 Str JOIN EXEC$A 100 492 453 580 17 0.0350 2456 Str JOIN SLOW$LIKE 2 103609 103336 103883 387 0.0037 2456 Str JOIN REALSLOW 2 404641 401993 407290 3746 0.0092 7950 Int UNPACK FIX$SINGLE 100 56 33 93 11 0.2028 7950 Int UNPACK FIX$MULTI 100 81 60 110 12 0.1426 7950 Int UNPACK TBLNUM$IL 100 102 76 126 11 0.1114 7950 Int UNPACK TBLNUM 100 112 93 156 11 0.0937 7950 Int UNPACK FIX$ITER 100 174 153 250 14 0.0828 7950 Int UNPACK ITER 100 193 170 220 12 0.0601 7950 Int UNPACK ITER$PROC 100 243 216 266 11 0.0470 7950 Int UNPACK XMLATTR 100 262 246 360 15 0.0567 7950 Int UNPACK XMLELEM 100 266 250 360 14 0.0520 7950 Int JOIN EXEC$B 100 83 60 170 17 0.2053 7950 Int JOIN FIX$SINGLE 100 83 60 126 12 0.1390 7950 Int JOIN FIX$MULTI 100 115 93 250 26 0.2261 7950 Int JOIN TBLNUM 100 136 123 173 9 0.0644 7950 Int JOIN TBLNUM$IL 100 140 110 330 32 0.2256 7950 Int JOIN FIX$ITER 100 197 186 233 10 0.0514 7950 Int JOIN ITER 100 222 186 263 15 0.0676 7950 Int JOIN XMLATTR 100 286 263 313 10 0.0352 7950 Int JOIN XMLELEM 100 289 266 343 10 0.0347 7950 Int JOIN ITER$PROC 100 528 250 610 97 0.1841 7950 Int JOIN EXEC$A 100 1508 1330 1673 73 0.0486 7950 Str UNPACK FIX$SINGLE 100 58 33 93 11 0.1890 7950 Str UNPACK FIX$MULTI 100 79 60 110 11 0.1420 7950 Str UNPACK TBLNUM 100 127 110 143 7 0.0571 7950 Str UNPACK TBLNUM$IL 100 134 106 296 28 0.2098 7950 Str UNPACK FIX$ITER 100 172 156 203 9 0.0526 7950 Str UNPACK ITER$PROC 100 182 156 220 11 0.0609 7950 Str UNPACK ITER 100 191 170 203 7 0.0390 7950 Str UNPACK XMLATTR 100 265 250 283 9 0.0344 7950 Str UNPACK XMLELEM 100 267 250 296 10 0.0369 7950 Str UNPACK ITER$EXEC 100 1223 1156 1283 25 0.0201 7950 Str JOIN EXEC$B 100 141 110 266 25 0.1791 7950 Str JOIN FIX$SINGLE 100 156 126 283 29 0.1867 7950 Str JOIN FIX$MULTI 100 174 153 373 27 0.1553 7950 Str JOIN TBLNUM 100 204 186 220 10 0.0484 7950 Str JOIN TBLNUM$IL 100 224 200 390 22 0.0985 7950 Str JOIN FIX$ITER 100 256 236 283 9 0.0338 7950 Str JOIN ITER 100 269 250 330 12 0.0428 7950 Str JOIN ITER$PROC 100 284 250 453 32 0.1131 7950 Str JOIN XMLATTR 100 341 326 360 11 0.0309 7950 Str JOIN XMLELEM 100 345 326 360 9 0.0264 7950 Str JOIN ITER$EXEC 100 1321 1250 1466 33 0.0247 7950 Str JOIN EXEC$A 100 2489 2326 2660 55 0.0219 23997 Int UNPACK FIX$SINGLE 100 79 60 156 14 0.1777 23997 Int UNPACK FIX$MULTI 100 156 126 296 28 0.1798 23997 Int UNPACK TBLNUM 100 234 216 253 9 0.0394 23997 Int UNPACK FIX$ITER 100 419 403 470 12 0.0290 23997 Int UNPACK ITER 100 478 450 516 11 0.0224 23997 Int UNPACK ITER$PROC 100 637 593 796 30 0.0473 23997 Int UNPACK XMLELEM 100 756 720 843 16 0.0212 23997 Int UNPACK XMLATTR 100 759 733 813 17 0.0227 23997 Int JOIN EXEC$B 100 147 123 266 17 0.1153 23997 Int JOIN FIX$SINGLE 100 164 140 280 22 0.1363 23997 Int JOIN FIX$MULTI 100 230 203 346 20 0.0878 23997 Int JOIN TBLNUM 100 310 293 343 10 0.0311 23997 Int JOIN FIX$ITER 100 499 480 656 20 0.0402 23997 Int JOIN ITER 100 550 530 563 8 0.0138 23997 Int JOIN XMLELEM 100 830 796 890 17 0.0200 23997 Int JOIN XMLATTR 100 831 796 920 19 0.0231 23997 Int JOIN ITER$PROC 100 958 703 1016 31 0.0325 23997 Int JOIN EXEC$A 100 12054 10953 12970 433 0.0359 23997 Str UNPACK FIX$SINGLE 100 92 60 250 23 0.2457 23997 Str UNPACK FIX$MULTI 100 156 126 313 29 0.1887 23997 Str UNPACK TBLNUM 100 293 280 603 32 0.1102 23997 Str UNPACK FIX$ITER 100 423 403 453 10 0.0234 23997 Str UNPACK ITER$PROC 100 431 403 516 13 0.0311 23997 Str UNPACK ITER 100 477 466 530 11 0.0221 23997 Str UNPACK XMLATTR 100 764 733 810 14 0.0185 23997 Str UNPACK XMLELEM 100 774 750 923 22 0.0283 23997 Str UNPACK ITER$EXEC 100 3570 3470 3716 48 0.0135 23997 Str JOIN EXEC$B 100 330 296 406 17 0.0507 23997 Str JOIN FIX$SINGLE 100 378 360 450 15 0.0405 23997 Str JOIN FIX$MULTI 100 411 373 466 27 0.0667 23997 Str JOIN TBLNUM 100 542 513 626 14 0.0264 23997 Str JOIN FIX$ITER 100 688 670 720 12 0.0167 23997 Str JOIN ITER 100 722 700 750 9 0.0130 23997 Str JOIN ITER$PROC 100 731 700 780 14 0.0188 23997 Str JOIN XMLATTR 100 1004 983 1080 16 0.0157 23997 Str JOIN XMLELEM 100 1011 983 1076 16 0.0161 23997 Str JOIN ITER$EXEC 100 3868 3750 4030 59 0.0151 23997 Str JOIN EXEC$A 100 14235 13626 14720 210 0.0147 120000 Int UNPACK FIX$MULTI 100 532 513 580 13 0.0246 120000 Int UNPACK TBLNUM 100 994 966 1033 12 0.0122 120000 Int UNPACK FIX$ITER 100 1876 1843 2000 21 0.0111 120000 Int UNPACK ITER 100 2175 2140 2453 37 0.0171 120000 Int UNPACK ITER$PROC 100 2852 2810 2953 26 0.0089 120000 Int UNPACK XMLATTR 100 3793 3746 3860 23 0.0060 120000 Int UNPACK XMLELEM 100 3820 3780 3906 24 0.0063 120000 Int JOIN FIX$MULTI 100 918 890 1190 38 0.0415 120000 Int JOIN TBLNUM 100 1406 1373 1470 14 0.0103 120000 Int JOIN FIX$ITER 100 2292 2263 2423 20 0.0088 120000 Int JOIN ITER 100 2573 2533 2670 21 0.0083 120000 Int JOIN ITER$PROC 100 3300 3263 3483 32 0.0096 120000 Int JOIN XMLATTR 100 4199 4153 4266 21 0.0050 120000 Int JOIN XMLELEM 100 4222 4156 4406 28 0.0067 120000 Str UNPACK FIX$MULTI 100 572 546 640 19 0.0326 120000 Str UNPACK TBLNUM 100 1311 1280 1376 20 0.0155 120000 Str UNPACK FIX$ITER 100 1916 1890 2110 24 0.0125 120000 Str UNPACK ITER$PROC 100 1943 1903 2093 36 0.0184 120000 Str UNPACK ITER 100 2211 2170 2250 15 0.0069 120000 Str UNPACK XMLATTR 100 3889 3796 3953 26 0.0065 120000 Str UNPACK XMLELEM 100 3919 3860 4000 23 0.0058 120000 Str JOIN FIX$MULTI 100 1673 1496 1940 155 0.0923 120000 Str JOIN TBLNUM 100 2434 2403 2500 19 0.0076 120000 Str JOIN ITER$PROC 100 3019 2983 3063 17 0.0054 120000 Str JOIN FIX$ITER 100 3144 3093 3203 17 0.0053 120000 Str JOIN ITER 100 3329 3296 3466 23 0.0070 120000 Str JOIN XMLATTR 100 4850 4780 5873 106 0.0219 120000 Str JOIN XMLELEM 100 4873 4780 4953 25 0.0051 Tool completed successfully