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 2 0 33 6 3.1322 237 Int UNPACK FIX$SINGLE 100 2 0 16 5 2.6526 237 Int UNPACK ITER 100 4 0 33 8 2.0013 237 Int UNPACK TBLNUM$IL 100 5 0 93 12 2.3180 237 Int UNPACK FIX$ITER 100 6 0 46 9 1.5408 237 Int UNPACK ITER$PROC 100 6 0 16 8 1.2543 237 Int UNPACK TBLNUM 100 6 0 33 8 1.3755 237 Int UNPACK XMLATTR 100 6 0 30 8 1.3330 237 Int UNPACK XMLELEM 100 6 0 46 10 1.5838 237 Int UNPACK UNION 100 9 0 46 9 0.9922 237 Int UNPACK INSERT 100 10 0 16 7 0.6988 237 Int JOIN FIX$SINGLE 100 3 0 16 6 2.1558 237 Int JOIN FIX$MULTI 100 5 0 16 7 1.4648 237 Int JOIN ITER 100 5 0 30 8 1.5407 237 Int JOIN TBLNUM$IL 100 5 0 80 10 2.0577 237 Int JOIN EXEC$B 100 6 0 16 7 1.2476 237 Int JOIN FIX$ITER 100 6 0 16 8 1.2692 237 Int JOIN ITER$PROC 100 6 0 16 8 1.2533 237 Int JOIN TBLNUM 100 7 0 33 9 1.3477 237 Int JOIN XMLELEM 100 7 0 46 9 1.3246 237 Int JOIN EXEC$A 100 8 0 46 10 1.2378 237 Int JOIN XMLATTR 100 9 0 203 22 2.4796 237 Int JOIN INSERT 100 11 0 30 7 0.6667 237 Int JOIN UNION 100 11 0 76 13 1.1376 237 Int JOIN REALSLOW 2 11273 10546 12000 1028 0.0912 237 Int JOIN SLOW$LIKE 2 11584 10826 12343 1073 0.0926 237 Str UNPACK FIX$SINGLE 100 3 0 30 6 2.1289 237 Str UNPACK FIX$MULTI 100 4 0 16 6 1.6236 237 Str UNPACK TBLNUM$IL 100 4 0 30 7 1.8573 237 Str UNPACK FIX$ITER 100 5 0 46 9 1.8193 237 Str UNPACK ITER 100 5 0 46 9 1.7587 237 Str UNPACK ITER$PROC 100 6 0 16 8 1.2607 237 Str UNPACK XMLELEM 100 6 0 33 8 1.3780 237 Str UNPACK XMLATTR 100 7 0 33 8 1.2002 237 Str UNPACK TBLNUM 100 8 0 46 10 1.2666 237 Str UNPACK UNION 100 9 0 33 8 0.8975 237 Str UNPACK INSERT 100 10 0 33 8 0.7504 237 Str UNPACK ITER$EXEC 100 14 0 33 5 0.3658 237 Str JOIN FIX$SINGLE 100 3 0 16 7 2.1777 237 Str JOIN EXEC$B 100 4 0 30 7 1.8713 237 Str JOIN FIX$ITER 100 4 0 33 8 1.9264 237 Str JOIN FIX$MULTI 100 5 0 46 8 1.6758 237 Str JOIN TBLNUM$IL 100 5 0 30 8 1.5166 237 Str JOIN ITER 100 7 0 143 16 2.2709 237 Str JOIN ITER$PROC 100 7 0 30 8 1.1298 237 Str JOIN XMLATTR 100 7 0 46 10 1.3808 237 Str JOIN XMLELEM 100 8 0 50 11 1.4162 237 Str JOIN TBLNUM 100 10 0 60 12 1.1945 237 Str JOIN UNION 100 11 0 30 7 0.6590 237 Str JOIN INSERT 100 12 0 16 6 0.4740 237 Str JOIN ITER$EXEC 100 16 0 33 5 0.3359 237 Str JOIN EXEC$A 100 38 30 63 8 0.2099 237 Str JOIN SLOW$LIKE 2 17921 17876 17966 64 0.0035 237 Str JOIN REALSLOW 2 18123 18076 18170 66 0.0036 2456 Int UNPACK FIX$SINGLE 100 4 0 30 7 1.8671 2456 Int UNPACK FIX$MULTI 100 5 0 30 8 1.5407 2456 Int UNPACK TBLNUM$IL 100 7 0 46 9 1.3069 2456 Int UNPACK TBLNUM 100 9 0 46 8 0.9199 2456 Int UNPACK ITER 100 15 0 46 5 0.3366 2456 Int UNPACK FIX$ITER 100 16 0 93 10 0.6067 2456 Int UNPACK XMLATTR 100 16 0 33 6 0.3699 2456 Int UNPACK XMLELEM 100 17 0 33 7 0.3997 2456 Int UNPACK ITER$PROC 100 24 13 46 9 0.3622 2456 Int UNPACK INSERT 100 75 60 93 7 0.0872 2456 Int UNPACK UNION 100 85 63 250 18 0.2173 2456 Int JOIN FIX$SINGLE 100 7 0 16 8 1.0992 2456 Int JOIN FIX$MULTI 100 10 0 80 11 1.1368 2456 Int JOIN TBLNUM 100 11 0 46 8 0.7043 2456 Int JOIN TBLNUM$IL 100 14 0 80 14 1.0106 2456 Int JOIN ITER 100 17 13 63 7 0.4119 2456 Int JOIN FIX$ITER 100 18 13 106 10 0.5816 2456 Int JOIN XMLATTR 100 19 13 33 8 0.4109 2456 Int JOIN XMLELEM 100 20 13 33 8 0.3931 2456 Int JOIN ITER$PROC 100 26 13 46 8 0.2922 2456 Int JOIN INSERT 100 79 63 93 6 0.0795 2456 Int JOIN UNION 100 87 76 110 9 0.1006 2456 Int JOIN EXEC$A 100 109 76 126 12 0.1095 2456 Int JOIN EXEC$B 100 109 76 140 13 0.1149 2456 Int JOIN REALSLOW 2 106179 104936 107423 1759 0.0165 2456 Int JOIN SLOW$LIKE 2 109469 108156 110783 1858 0.0169 2456 Str UNPACK FIX$SINGLE 100 3 0 30 7 2.4364 2456 Str UNPACK FIX$MULTI 100 6 0 33 8 1.3502 2456 Str UNPACK TBLNUM$IL 100 9 0 16 7 0.8193 2456 Str UNPACK TBLNUM 100 13 0 76 11 0.8228 2456 Str UNPACK FIX$ITER 100 15 0 33 4 0.2700 2456 Str UNPACK ITER 100 17 13 63 8 0.4929 2456 Str UNPACK ITER$PROC 100 17 0 33 6 0.3706 2456 Str UNPACK XMLATTR 100 18 0 46 8 0.4450 2456 Str UNPACK XMLELEM 100 19 0 50 9 0.4493 2456 Str UNPACK INSERT 100 100 93 110 8 0.0807 2456 Str UNPACK UNION 100 105 93 123 7 0.0700 2456 Str UNPACK ITER$EXEC 100 125 106 156 8 0.0643 2456 Str JOIN FIX$SINGLE 100 14 0 33 6 0.4109 2456 Str JOIN FIX$MULTI 100 15 0 33 7 0.4611 2456 Str JOIN TBLNUM 100 18 13 186 18 0.9927 2456 Str JOIN TBLNUM$IL 100 20 13 76 9 0.4669 2456 Str JOIN FIX$ITER 100 22 13 33 8 0.3703 2456 Str JOIN ITER 100 24 13 93 13 0.5373 2456 Str JOIN XMLELEM 100 25 13 33 8 0.3118 2456 Str JOIN XMLATTR 100 26 13 63 8 0.3182 2456 Str JOIN ITER$PROC 100 28 13 93 9 0.3361 2456 Str JOIN INSERT 100 111 93 126 8 0.0680 2456 Str JOIN UNION 100 116 93 140 9 0.0738 2456 Str JOIN ITER$EXEC 100 136 123 156 9 0.0655 2456 Str JOIN EXEC$B 100 167 13 190 39 0.2327 2456 Str JOIN EXEC$A 100 175 156 190 7 0.0409 2456 Str JOIN REALSLOW 2 175563 173906 177220 2343 0.0133 2456 Str JOIN SLOW$LIKE 2 176415 172470 180360 5579 0.0316 7950 Int UNPACK FIX$SINGLE 100 6 0 46 8 1.4005 7950 Int UNPACK FIX$MULTI 100 14 0 30 4 0.2995 7950 Int UNPACK TBLNUM$IL 100 21 13 33 8 0.3809 7950 Int UNPACK TBLNUM 100 22 13 46 8 0.3817 7950 Int UNPACK FIX$ITER 100 41 30 50 7 0.1809 7950 Int UNPACK ITER 100 41 30 50 7 0.1797 7950 Int UNPACK XMLATTR 100 56 46 76 8 0.1483 7950 Int UNPACK XMLELEM 100 57 46 63 8 0.1319 7950 Int UNPACK ITER$PROC 100 65 46 93 8 0.1230 7950 Int JOIN EXEC$B 100 15 0 33 4 0.2833 7950 Int JOIN FIX$SINGLE 100 16 0 33 5 0.3145 7950 Int JOIN FIX$MULTI 100 21 13 33 8 0.3852 7950 Int JOIN TBLNUM 100 28 13 33 6 0.2043 7950 Int JOIN TBLNUM$IL 100 29 13 46 7 0.2347 7950 Int JOIN FIX$ITER 100 48 46 63 6 0.1250 7950 Int JOIN ITER 100 51 46 330 29 0.5642 7950 Int JOIN XMLATTR 100 63 46 80 5 0.0829 7950 Int JOIN XMLELEM 100 64 46 80 6 0.0992 7950 Int JOIN ITER$PROC 100 157 80 173 10 0.0641 7950 Int JOIN EXEC$A 100 933 783 1063 58 0.0619 7950 Str UNPACK FIX$SINGLE 100 6 0 16 7 1.2374 7950 Str UNPACK FIX$MULTI 100 14 0 33 5 0.3450 7950 Str UNPACK TBLNUM 100 27 13 33 7 0.2467 7950 Str UNPACK TBLNUM$IL 100 30 13 46 5 0.1759 7950 Str UNPACK FIX$ITER 100 41 30 50 7 0.1688 7950 Str UNPACK ITER$PROC 100 43 30 80 7 0.1689 7950 Str UNPACK ITER 100 47 30 63 5 0.1034 7950 Str UNPACK XMLATTR 100 59 46 63 7 0.1104 7950 Str UNPACK XMLELEM 100 59 46 110 8 0.1373 7950 Str UNPACK ITER$EXEC 100 389 373 436 12 0.0314 7950 Str JOIN FIX$SINGLE 100 35 30 76 8 0.2360 7950 Str JOIN FIX$MULTI 100 40 30 90 9 0.2366 7950 Str JOIN TBLNUM 100 49 46 63 7 0.1350 7950 Str JOIN TBLNUM$IL 100 55 46 63 8 0.1481 7950 Str JOIN FIX$ITER 100 65 60 80 7 0.1085 7950 Str JOIN ITER 100 69 60 80 8 0.1167 7950 Str JOIN ITER$PROC 100 73 60 110 9 0.1259 7950 Str JOIN XMLATTR 100 80 76 96 7 0.0823 7950 Str JOIN XMLELEM 100 82 76 96 8 0.0940 7950 Str JOIN EXEC$B 100 178 170 203 8 0.0453 7950 Str JOIN ITER$EXEC 100 418 403 546 16 0.0385 7950 Str JOIN EXEC$A 100 1256 1170 1326 33 0.0260 23997 Int UNPACK FIX$SINGLE 100 12 0 46 7 0.5588 23997 Int UNPACK FIX$MULTI 100 31 13 63 4 0.1445 23997 Int UNPACK TBLNUM 100 58 46 76 7 0.1245 23997 Int UNPACK FIX$ITER 100 114 106 126 8 0.0689 23997 Int UNPACK ITER 100 122 106 280 17 0.1416 23997 Int UNPACK XMLATTR 100 170 153 203 9 0.0512 23997 Int UNPACK XMLELEM 100 170 156 186 6 0.0371 23997 Int UNPACK ITER$PROC 100 176 156 236 10 0.0546 23997 Int JOIN EXEC$B 100 30 13 46 5 0.1652 23997 Int JOIN FIX$SINGLE 100 35 30 60 7 0.2075 23997 Int JOIN FIX$MULTI 100 54 46 80 9 0.1652 23997 Int JOIN TBLNUM 100 79 76 110 6 0.0721 23997 Int JOIN FIX$ITER 100 134 123 143 8 0.0585 23997 Int JOIN ITER 100 140 123 156 6 0.0398 23997 Int JOIN XMLATTR 100 187 170 216 6 0.0331 23997 Int JOIN XMLELEM 100 188 170 203 7 0.0382 23997 Int JOIN ITER$PROC 100 277 263 300 9 0.0329 23997 Int JOIN EXEC$A 100 8684 7653 9500 379 0.0435 23997 Str UNPACK FIX$SINGLE 100 13 0 33 6 0.4688 23997 Str UNPACK FIX$MULTI 100 31 13 63 5 0.1765 23997 Str UNPACK TBLNUM 100 78 60 156 10 0.1284 23997 Str UNPACK FIX$ITER 100 117 106 203 12 0.1004 23997 Str UNPACK ITER$PROC 100 117 106 143 9 0.0788 23997 Str UNPACK ITER 100 133 123 156 8 0.0625 23997 Str UNPACK XMLATTR 100 174 170 190 6 0.0354 23997 Str UNPACK XMLELEM 100 176 170 190 7 0.0407 23997 Str UNPACK ITER$EXEC 100 1147 1106 1203 14 0.0123 23997 Str JOIN FIX$SINGLE 100 91 76 110 6 0.0646 23997 Str JOIN FIX$MULTI 100 108 93 126 5 0.0478 23997 Str JOIN TBLNUM 100 142 123 220 9 0.0636 23997 Str JOIN FIX$ITER 100 187 170 216 6 0.0318 23997 Str JOIN EXEC$B 100 193 186 220 9 0.0452 23997 Str JOIN ITER$PROC 100 196 186 216 8 0.0420 23997 Str JOIN ITER 100 197 186 216 8 0.0405 23997 Str JOIN XMLATTR 100 242 233 266 9 0.0362 23997 Str JOIN XMLELEM 100 246 233 360 14 0.0568 23997 Str JOIN ITER$EXEC 100 1226 1200 1266 14 0.0112 23997 Str JOIN EXEC$A 100 11883 11296 12703 286 0.0240 120000 Int UNPACK FIX$MULTI 100 121 106 143 7 0.0542 120000 Int UNPACK TBLNUM 100 283 263 360 10 0.0366 120000 Int UNPACK FIX$ITER 100 545 530 593 10 0.0186 120000 Int UNPACK ITER 100 574 560 673 13 0.0231 120000 Int UNPACK ITER$PROC 100 829 810 923 13 0.0157 120000 Int UNPACK XMLATTR 100 836 826 846 9 0.0101 120000 Int UNPACK XMLELEM 100 840 826 860 9 0.0101 120000 Int JOIN FIX$MULTI 100 239 233 313 11 0.0469 120000 Int JOIN TBLNUM 100 384 373 406 9 0.0235 120000 Int JOIN FIX$ITER 100 647 640 733 13 0.0199 120000 Int JOIN ITER 100 672 653 780 14 0.0207 120000 Int JOIN XMLATTR 100 935 920 1030 13 0.0134 120000 Int JOIN XMLELEM 100 936 920 956 8 0.0085 120000 Int JOIN ITER$PROC 100 960 936 1110 19 0.0198 120000 Str UNPACK FIX$MULTI 100 129 123 156 8 0.0626 120000 Str UNPACK TBLNUM 100 375 356 406 7 0.0190 120000 Str UNPACK ITER$PROC 100 547 530 736 21 0.0376 120000 Str UNPACK FIX$ITER 100 554 546 640 16 0.0284 120000 Str UNPACK ITER 100 640 623 656 7 0.0110 120000 Str UNPACK XMLATTR 100 858 840 876 8 0.0094 120000 Str UNPACK XMLELEM 100 867 856 906 9 0.0104 120000 Str JOIN FIX$MULTI 100 464 453 500 8 0.0173 120000 Str JOIN TBLNUM 100 683 670 706 8 0.0116 120000 Str JOIN ITER$PROC 100 838 826 906 11 0.0128 120000 Str JOIN FIX$ITER 100 897 873 1076 20 0.0227 120000 Str JOIN ITER 100 947 923 1000 11 0.0120 120000 Str JOIN XMLATTR 100 1134 1123 1170 10 0.0091 120000 Str JOIN XMLELEM 100 1136 1110 1156 9 0.0078 Tool completed successfully