Size Data Optype Method Cnt Avg Min Max Median Stdev Varcoeff ---- ---- ------ ------ --- --- --- --- ------ ----- -------- 20 Int UNPACK CLR$FIX 100 0 0 16 0 4 0.000 20 Int UNPACK CLR$ITER 100 0 0 16 0 3 0.000 20 Int UNPACK CTE$CHUNK 100 0 0 16 0 4 0.000 20 Int UNPACK FIX$BINARY 100 0 0 16 0 3 0.000 20 Int UNPACK FIX$SINGLE 100 0 0 16 0 3 0.000 20 Int UNPACK TBLNUM$NOCNV 100 0 0 16 0 3 0.000 20 Int UNPACK CLR$SPLIT 100 1 0 16 0 5 4.795 20 Int UNPACK CTE$IL 100 1 0 16 0 5 4.795 20 Int UNPACK FIX$ITER 100 1 0 16 0 5 5.001 20 Int UNPACK FIX$MSTMT 100 1 0 16 0 4 4.003 20 Int UNPACK FIX$MULTI 100 1 0 16 0 5 4.875 20 Int UNPACK ITER$CHUNK 100 1 0 16 0 5 5.046 20 Int UNPACK ITER$SIMPLE 100 1 0 16 0 5 5.194 20 Int UNPACK TBLNUM 100 1 0 16 0 5 4.713 20 Int UNPACK TBLNUM$DUO 100 1 0 16 0 5 4.713 20 Int UNPACK TBLNUM$IL 100 1 0 16 0 4 4.398 20 Int UNPACK TBLNUM$ILOLD 100 1 0 16 0 4 3.794 20 Int UNPACK TBLNUM$NOBIN 100 1 0 16 0 4 3.685 20 Int UNPACK XMLATTR 100 1 0 16 0 4 3.900 20 Int UNPACK XMLATTR$OPEN 100 1 0 16 0 5 4.970 20 Int UNPACK XMLELEM 100 1 0 16 0 5 5.121 20 Int UNPACK XMLELEM$OPEN 100 1 0 16 0 4 4.335 20 Int UNPACK FIX$MULTI2 100 2 0 16 0 5 2.617 20 Int UNPACK MANYSELECT 100 2 0 16 0 6 2.942 20 Int UNPACK XMLATTR$STR 100 2 0 16 0 6 2.885 20 Int UNPACK MANYUNION 100 3 0 16 0 6 2.159 20 Int UNPACK CTE$MSTMT 100 6 0 16 0 8 1.277 20 Int UNPACK MANYINSERT 100 14 0 16 16 4 0.255 20 Int JOIN CLR$SPLIT 100 0 0 16 0 4 0.000 20 Int JOIN CTE$IL 100 0 0 16 0 4 0.000 20 Int JOIN EXEC$B 100 0 0 16 0 3 0.000 20 Int JOIN FIX$SINGLE 100 0 0 16 0 4 0.000 20 Int JOIN FIX$TMPTBL 100 0 0 16 0 3 0.000 20 Int JOIN CLR$FIX 100 1 0 16 0 4 3.900 20 Int JOIN FIX$BINARY 100 1 0 16 0 5 5.077 20 Int JOIN FIX$ITER 100 1 0 16 0 4 4.147 20 Int JOIN FIX$MSTMT 100 1 0 16 0 4 4.174 20 Int JOIN TBLNUM 100 1 0 16 0 4 3.900 20 Int JOIN TBLNUM$NOBIN 100 1 0 16 0 5 4.713 20 Int JOIN TBLNUM$NOCNV 100 1 0 16 0 4 4.242 20 Int JOIN XMLATTR 100 1 0 16 0 5 4.924 20 Int JOIN XMLATTR$OPEN 100 1 0 16 0 5 4.713 20 Int JOIN XMLATTR$STR 100 1 0 16 0 5 4.795 20 Int JOIN XMLATTR$TMPTBL 100 1 0 16 0 4 4.487 20 Int JOIN XMLATTR$TVAR 100 1 0 16 0 4 3.873 20 Int JOIN XMLELEM 100 1 0 16 0 5 4.574 20 Int JOIN XMLELEM$OPEN 100 1 0 16 0 5 5.121 20 Int JOIN CLR$ITER 100 2 0 16 0 6 2.836 20 Int JOIN CTE$CHUNK 100 2 0 16 0 5 2.688 20 Int JOIN ITER$CHUNK 100 2 0 16 0 6 2.836 20 Int JOIN ITER$SIMPLE 100 2 0 16 0 5 2.671 20 Int JOIN MANYSELECT 100 2 0 16 0 5 2.581 20 Int JOIN TBLNUM$DUO 100 2 0 16 0 6 2.899 20 Int JOIN TBLNUM$IL 100 2 0 16 0 6 2.756 20 Int JOIN FIX$MULTI 100 3 0 16 0 6 2.021 20 Int JOIN FIX$MULTI2 100 3 0 16 0 6 2.117 20 Int JOIN MANYUNION 100 3 0 16 0 6 2.161 20 Int JOIN TBLNUM$ILOLD 100 3 0 16 0 6 2.034 20 Int JOIN EXEC$A 100 4 0 16 0 7 1.781 20 Int JOIN CTE$MSTMT 100 6 0 16 0 8 1.255 20 Int JOIN MANYINSERT 100 14 0 16 16 3 0.233 20 Int JOIN REALSLOW 35 2402 2313 2483 2406 53 0.022 20 Int JOIN SLOW$LIKE 33 2975 2796 3153 2953 87 0.029 20 Str UNPACK CLR$FIX 100 0 0 16 0 3 0.000 20 Str UNPACK CLR$SPLIT 100 0 0 16 0 4 0.000 20 Str UNPACK CTE$IL 100 0 0 16 0 4 0.000 20 Str UNPACK FIX$MSTMT 100 0 0 16 0 3 0.000 20 Str UNPACK FIX$SINGLE 100 0 0 16 0 3 0.000 20 Str UNPACK TBLNUM$IL 100 0 0 16 0 4 0.000 20 Str UNPACK XMLATTR 100 0 0 16 0 3 0.000 20 Str UNPACK CLR$ITER 100 1 0 16 0 5 5.001 20 Str UNPACK CTE$CHUNK 100 1 0 16 0 4 4.147 20 Str UNPACK FIX$MULTI 100 1 0 16 0 5 4.795 20 Str UNPACK FIX$MULTI2 100 1 0 16 0 4 4.398 20 Str UNPACK ITER$CHUNK 100 1 0 16 0 5 5.121 20 Str UNPACK ITER$SIMPLE 100 1 0 16 0 5 4.544 20 Str UNPACK TBLNUM 100 1 0 16 0 4 4.335 20 Str UNPACK TBLNUM$DUO 100 1 0 16 0 4 4.077 20 Str UNPACK TBLNUM$ILOLD 100 1 0 16 0 4 4.003 20 Str UNPACK TBLNUM$NOBIN 100 1 0 16 0 5 4.764 20 Str UNPACK TBLNUM$NOCNV 100 1 0 16 0 4 4.426 20 Str UNPACK XMLATTR$STR 100 1 0 16 0 4 4.174 20 Str UNPACK XMLELEM 100 1 0 16 0 5 4.924 20 Str UNPACK XMLELEM$OPEN 100 1 0 16 0 5 4.629 20 Str UNPACK FIX$ITER 100 2 0 16 0 6 2.789 20 Str UNPACK XMLATTR$OPEN 100 2 0 16 0 5 2.722 20 Str UNPACK MANYSELECT 100 3 0 16 0 7 2.178 20 Str UNPACK CTE$MSTMT 100 5 0 16 0 7 1.454 20 Str UNPACK MANYUNION 100 5 0 16 0 8 1.502 20 Str UNPACK MANYINSERT 100 15 13 33 16 4 0.247 20 Str JOIN XMLATTR$TVAR 100 0 0 16 0 4 0.000 20 Str JOIN CLR$ITER 100 1 0 16 0 4 4.398 20 Str JOIN CLR$SPLIT 100 1 0 16 0 4 4.426 20 Str JOIN EXEC$B 100 1 0 16 0 4 4.174 20 Str JOIN FIX$ITER 100 1 0 16 0 5 5.001 20 Str JOIN FIX$MSTMT 100 1 0 16 0 5 5.121 20 Str JOIN FIX$SINGLE 100 1 0 16 0 5 4.659 20 Str JOIN FIX$TMPTBL 100 1 0 16 0 5 5.001 20 Str JOIN ITER$SIMPLE 100 1 0 16 0 5 4.795 20 Str JOIN TBLNUM 100 1 0 16 0 4 4.426 20 Str JOIN TBLNUM$DUO 100 1 0 16 0 5 5.001 20 Str JOIN TBLNUM$NOCNV 100 1 0 16 0 5 4.924 20 Str JOIN XMLATTR$OPEN 100 1 0 16 0 5 4.713 20 Str JOIN XMLATTR$STR 100 1 0 16 0 5 4.574 20 Str JOIN XMLATTR$TMPTBL 100 1 0 16 0 4 4.174 20 Str JOIN XMLELEM 100 1 0 16 0 4 4.174 20 Str JOIN XMLELEM$OPEN 100 1 0 16 0 4 4.174 20 Str JOIN CLR$FIX 100 2 0 16 0 5 2.669 20 Str JOIN CTE$IL 100 2 0 16 0 5 2.740 20 Str JOIN ITER$CHUNK 100 2 0 16 0 6 2.972 20 Str JOIN XMLATTR 100 2 0 16 0 6 2.822 20 Str JOIN CTE$CHUNK 100 3 0 17 0 6 2.159 20 Str JOIN FIX$MULTI 100 3 0 16 0 7 2.192 20 Str JOIN MANYUNION 100 3 0 16 0 7 2.212 20 Str JOIN TBLNUM$ILOLD 100 3 0 16 0 7 2.192 20 Str JOIN TBLNUM$NOBIN 100 3 0 16 0 6 2.159 20 Str JOIN FIX$MULTI2 100 4 0 16 0 7 1.728 20 Str JOIN MANYSELECT 100 4 0 16 0 7 1.716 20 Str JOIN TBLNUM$IL 100 4 0 16 0 7 1.683 20 Str JOIN CTE$MSTMT 100 5 0 16 0 7 1.430 20 Str JOIN EXEC$A 100 5 0 16 0 7 1.483 20 Str JOIN MANYINSERT 100 16 13 33 16 5 0.322 20 Str JOIN REALSLOW 35 22679 21063 25000 22580 1042 0.046 20 Str JOIN SLOW$LIKE 33 23659 21700 26093 23610 1125 0.048 ------------------------------------------------------------------------------ 200 Int UNPACK CLR$FIX 100 2 0 16 0 6 2.785 200 Int UNPACK CLR$ITER 100 2 0 16 0 6 2.983 200 Int UNPACK CLR$SPLIT 100 2 0 16 0 5 2.670 200 Int UNPACK FIX$BINARY 100 2 0 16 0 5 2.654 200 Int UNPACK FIX$MULTI 100 2 0 16 0 6 3.022 200 Int UNPACK FIX$SINGLE 100 2 0 16 0 5 2.653 200 Int UNPACK TBLNUM$DUO 100 3 0 16 0 7 2.225 200 Int UNPACK TBLNUM$IL 100 3 0 16 0 7 2.228 200 Int UNPACK FIX$MSTMT 100 4 0 16 0 7 1.747 200 Int UNPACK FIX$MULTI2 100 4 0 16 0 7 1.766 200 Int UNPACK TBLNUM 100 4 0 16 0 7 1.774 200 Int UNPACK TBLNUM$NOCNV 100 4 0 16 0 7 1.717 200 Int UNPACK XMLATTR 100 4 0 16 0 7 1.794 200 Int UNPACK TBLNUM$ILOLD 100 5 0 16 0 7 1.457 200 Int UNPACK TBLNUM$NOBIN 100 5 0 16 0 7 1.483 200 Int UNPACK XMLATTR$OPEN 100 5 0 16 0 7 1.426 200 Int UNPACK XMLATTR$STR 100 5 0 16 0 7 1.483 200 Int UNPACK CTE$IL 100 6 0 16 0 8 1.300 200 Int UNPACK XMLELEM 100 6 0 16 0 8 1.261 200 Int UNPACK XMLELEM$OPEN 100 6 0 16 0 8 1.261 200 Int UNPACK FIX$ITER 100 7 0 16 6 8 1.105 200 Int UNPACK ITER$CHUNK 100 7 0 16 13 8 1.094 200 Int UNPACK CTE$CHUNK 100 8 0 16 13 8 0.951 200 Int UNPACK MANYSELECT 100 9 0 16 13 7 0.819 200 Int UNPACK ITER$SIMPLE 100 10 0 16 13 7 0.695 200 Int UNPACK CTE$MSTMT 100 12 0 16 16 5 0.446 200 Int UNPACK MANYUNION 100 39 30 50 46 8 0.199 200 Int UNPACK MANYINSERT 100 152 123 173 156 9 0.062 200 Int JOIN EXEC$B 100 1 0 16 0 5 4.875 200 Int JOIN CLR$FIX 100 3 0 16 0 7 2.244 200 Int JOIN CLR$SPLIT 100 3 0 16 0 7 2.227 200 Int JOIN FIX$BINARY 100 3 0 16 0 7 2.227 200 Int JOIN FIX$SINGLE 100 3 0 16 0 6 2.081 200 Int JOIN CLR$ITER 100 4 0 16 0 7 1.768 200 Int JOIN FIX$MULTI 100 4 0 16 0 7 1.784 200 Int JOIN FIX$MULTI2 100 4 0 16 0 7 1.695 200 Int JOIN FIX$TMPTBL 100 4 0 16 0 7 1.768 200 Int JOIN TBLNUM$DUO 100 5 0 16 0 7 1.487 200 Int JOIN XMLATTR 100 5 0 16 0 7 1.483 200 Int JOIN FIX$MSTMT 100 6 0 16 0 7 1.250 200 Int JOIN TBLNUM 100 6 0 16 0 8 1.290 200 Int JOIN TBLNUM$NOCNV 100 6 0 16 0 8 1.259 200 Int JOIN XMLATTR$STR 100 6 0 16 0 7 1.243 200 Int JOIN XMLATTR$TMPTBL 100 6 0 16 0 8 1.261 200 Int JOIN XMLATTR$TVAR 100 6 0 16 0 8 1.265 200 Int JOIN CTE$CHUNK 100 7 0 16 13 8 1.082 200 Int JOIN CTE$IL 100 7 0 16 0 8 1.095 200 Int JOIN TBLNUM$IL 100 7 0 16 13 8 1.072 200 Int JOIN TBLNUM$ILOLD 100 7 0 16 6 8 1.101 200 Int JOIN XMLATTR$OPEN 100 7 0 16 13 7 1.069 200 Int JOIN XMLELEM 100 7 0 16 0 8 1.103 200 Int JOIN TBLNUM$NOBIN 100 9 0 16 13 7 0.833 200 Int JOIN XMLELEM$OPEN 100 9 0 16 13 8 0.843 200 Int JOIN FIX$ITER 100 10 0 16 16 7 0.701 200 Int JOIN ITER$CHUNK 100 10 0 30 14 7 0.746 200 Int JOIN MANYSELECT 100 10 0 16 13 7 0.733 200 Int JOIN ITER$SIMPLE 100 12 0 16 16 6 0.508 200 Int JOIN CTE$MSTMT 100 13 0 16 16 4 0.328 200 Int JOIN EXEC$A 100 23 13 33 30 8 0.352 200 Int JOIN MANYUNION 100 38 30 50 33 8 0.202 200 Int JOIN MANYINSERT 100 153 123 173 156 9 0.061 200 Int JOIN REALSLOW 2 10749 10703 10796 10749 66 0.006 200 Int JOIN SLOW$LIKE 2 13828 13470 14186 13828 506 0.037 200 Str UNPACK FIX$SINGLE 100 1 0 16 0 5 4.924 200 Str UNPACK CLR$SPLIT 100 2 0 16 0 6 2.983 200 Str UNPACK CLR$FIX 100 3 0 16 0 6 2.095 200 Str UNPACK CLR$ITER 100 3 0 16 0 6 2.135 200 Str UNPACK FIX$MSTMT 100 3 0 16 0 6 2.049 200 Str UNPACK FIX$MULTI 100 3 0 16 0 6 2.040 200 Str UNPACK FIX$MULTI2 100 3 0 16 0 7 2.192 200 Str UNPACK TBLNUM 100 3 0 16 0 7 2.212 200 Str UNPACK TBLNUM$DUO 100 3 0 16 0 6 2.142 200 Str UNPACK XMLATTR 100 3 0 16 0 7 2.211 200 Str UNPACK XMLATTR$OPEN 100 5 0 16 0 7 1.464 200 Str UNPACK XMLATTR$STR 100 5 0 16 0 7 1.445 200 Str UNPACK CTE$IL 100 6 0 16 0 7 1.249 200 Str UNPACK TBLNUM$IL 100 6 0 16 0 7 1.245 200 Str UNPACK TBLNUM$ILOLD 100 6 0 16 0 7 1.232 200 Str UNPACK TBLNUM$NOCNV 100 6 0 16 0 8 1.271 200 Str UNPACK XMLELEM$OPEN 100 6 0 16 0 8 1.276 200 Str UNPACK CTE$CHUNK 100 7 0 16 0 8 1.111 200 Str UNPACK FIX$ITER 100 7 0 16 0 8 1.091 200 Str UNPACK ITER$CHUNK 100 7 0 16 0 8 1.081 200 Str UNPACK XMLELEM 100 7 0 16 0 8 1.087 200 Str UNPACK TBLNUM$NOBIN 100 8 0 16 13 8 0.947 200 Str UNPACK CTE$MSTMT 100 11 0 16 16 6 0.574 200 Str UNPACK ITER$SIMPLE 100 11 0 16 16 7 0.619 200 Str UNPACK MANYSELECT 100 15 13 16 16 1 0.091 200 Str UNPACK MANYUNION 100 99 90 110 96 8 0.080 200 Str UNPACK MANYINSERT 100 173 153 203 173 11 0.061 200 Str JOIN EXEC$B 100 3 0 16 0 6 2.021 200 Str JOIN FIX$SINGLE 100 4 0 16 0 7 1.817 200 Str JOIN CLR$FIX 100 6 0 16 0 7 1.233 200 Str JOIN CLR$SPLIT 100 6 0 16 0 7 1.243 200 Str JOIN FIX$MSTMT 100 6 0 16 0 8 1.261 200 Str JOIN CLR$ITER 100 7 0 16 0 8 1.081 200 Str JOIN TBLNUM$DUO 100 7 0 16 13 8 1.098 200 Str JOIN XMLATTR$TMPTBL 100 7 0 16 13 8 1.083 200 Str JOIN FIX$TMPTBL 100 8 0 16 13 8 0.974 200 Str JOIN TBLNUM 100 8 0 16 13 8 0.945 200 Str JOIN XMLATTR 100 8 0 16 13 8 0.964 200 Str JOIN XMLATTR$TVAR 100 8 0 16 13 8 0.955 200 Str JOIN CTE$CHUNK 100 9 0 16 13 7 0.827 200 Str JOIN FIX$MULTI 100 9 0 16 13 7 0.826 200 Str JOIN FIX$MULTI2 100 9 0 16 13 8 0.842 200 Str JOIN TBLNUM$IL 100 9 0 16 13 7 0.788 200 Str JOIN XMLATTR$STR 100 9 0 16 13 7 0.808 200 Str JOIN CTE$IL 100 10 0 16 13 7 0.709 200 Str JOIN XMLATTR$OPEN 100 10 0 16 16 7 0.726 200 Str JOIN XMLELEM 100 10 0 33 13 8 0.752 200 Str JOIN XMLELEM$OPEN 100 10 0 16 13 7 0.720 200 Str JOIN FIX$ITER 100 11 0 16 16 6 0.559 200 Str JOIN TBLNUM$ILOLD 100 11 0 16 14 6 0.586 200 Str JOIN TBLNUM$NOCNV 100 11 0 16 16 7 0.640 200 Str JOIN ITER$CHUNK 100 12 0 16 16 6 0.529 200 Str JOIN ITER$SIMPLE 100 13 0 16 16 5 0.350 200 Str JOIN TBLNUM$NOBIN 100 13 0 16 16 5 0.392 200 Str JOIN CTE$MSTMT 100 16 13 33 16 5 0.326 200 Str JOIN MANYSELECT 100 18 13 33 16 7 0.375 200 Str JOIN EXEC$A 100 42 30 50 46 7 0.159 200 Str JOIN MANYUNION 100 102 90 123 106 8 0.082 200 Str JOIN MANYINSERT 100 177 153 206 173 10 0.057 200 Str JOIN REALSLOW 2 225718 224890 226546 225718 1171 0.005 200 Str JOIN SLOW$LIKE 2 233216 233123 233310 233216 132 0.001 ------------------------------------------------------------------------------ 650 Int UNPACK FIX$BINARY 100 5 0 16 0 7 1.454 650 Int UNPACK CLR$FIX 100 6 0 16 0 7 1.250 650 Int UNPACK CLR$SPLIT 100 6 0 16 0 7 1.217 650 Int UNPACK FIX$SINGLE 100 6 0 16 0 8 1.271 650 Int UNPACK CLR$ITER 100 7 0 16 0 8 1.077 650 Int UNPACK FIX$MULTI 100 8 0 16 13 8 0.957 650 Int UNPACK FIX$MULTI2 100 8 0 16 13 8 0.943 650 Int UNPACK TBLNUM 100 9 0 16 13 7 0.819 650 Int UNPACK FIX$MSTMT 100 10 0 16 13 7 0.719 650 Int UNPACK TBLNUM$DUO 100 10 0 16 16 7 0.708 650 Int UNPACK XMLATTR 100 11 0 16 16 7 0.598 650 Int UNPACK TBLNUM$IL 100 14 13 30 16 2 0.152 650 Int UNPACK TBLNUM$ILOLD 100 15 13 30 16 3 0.193 650 Int UNPACK TBLNUM$NOCNV 100 16 13 33 16 4 0.268 650 Int UNPACK XMLATTR$STR 100 17 13 30 16 5 0.307 650 Int UNPACK XMLELEM 100 18 13 33 16 7 0.371 650 Int UNPACK TBLNUM$NOBIN 100 19 13 33 16 8 0.397 650 Int UNPACK CTE$CHUNK 100 20 13 33 16 8 0.381 650 Int UNPACK CTE$IL 100 21 13 33 16 8 0.386 650 Int UNPACK MANYSELECT 100 24 13 33 30 8 0.345 650 Int UNPACK FIX$ITER 100 27 13 46 30 7 0.266 650 Int UNPACK ITER$CHUNK 100 27 13 33 30 7 0.248 650 Int UNPACK XMLATTR$OPEN 100 28 13 33 30 6 0.209 650 Int UNPACK XMLELEM$OPEN 100 28 13 33 30 5 0.193 650 Int UNPACK CTE$MSTMT 100 31 30 46 30 3 0.082 650 Int UNPACK ITER$SIMPLE 100 37 30 50 33 8 0.206 650 Int UNPACK MANYUNION 100 312 293 346 313 11 0.034 650 Int UNPACK MANYINSERT 100 463 406 516 446 35 0.076 650 Int JOIN EXEC$B 100 5 0 16 0 7 1.431 650 Int JOIN FIX$MULTI 100 8 0 16 13 8 0.942 650 Int JOIN FIX$SINGLE 100 8 0 16 13 8 0.955 650 Int JOIN FIX$BINARY 100 9 0 33 13 8 0.872 650 Int JOIN FIX$MULTI2 100 9 0 16 13 7 0.786 650 Int JOIN CLR$FIX 100 11 0 16 16 7 0.619 650 Int JOIN CLR$ITER 100 11 0 16 16 7 0.615 650 Int JOIN CLR$SPLIT 100 11 0 33 16 7 0.608 650 Int JOIN FIX$MSTMT 100 12 0 16 16 6 0.460 650 Int JOIN FIX$TMPTBL 100 12 0 16 16 5 0.445 650 Int JOIN TBLNUM 100 14 0 16 16 3 0.179 650 Int JOIN TBLNUM$DUO 100 14 0 16 16 3 0.209 650 Int JOIN XMLATTR 100 16 13 33 16 5 0.282 650 Int JOIN XMLATTR$TVAR 100 16 13 33 16 5 0.323 650 Int JOIN XMLATTR$TMPTBL 100 18 13 33 16 7 0.397 650 Int JOIN TBLNUM$IL 100 19 13 33 16 7 0.377 650 Int JOIN XMLATTR$STR 100 19 13 33 16 8 0.426 650 Int JOIN TBLNUM$ILOLD 100 20 13 33 16 8 0.389 650 Int JOIN TBLNUM$NOCNV 100 21 13 33 16 8 0.374 650 Int JOIN XMLELEM 100 22 13 33 16 8 0.370 650 Int JOIN TBLNUM$NOBIN 100 23 13 33 30 8 0.356 650 Int JOIN CTE$CHUNK 100 25 13 46 30 8 0.325 650 Int JOIN CTE$IL 100 27 13 46 30 7 0.266 650 Int JOIN MANYSELECT 100 29 13 50 30 5 0.185 650 Int JOIN FIX$ITER 100 30 13 33 30 3 0.107 650 Int JOIN ITER$CHUNK 100 31 13 46 33 4 0.117 650 Int JOIN XMLATTR$OPEN 100 33 30 46 30 6 0.167 650 Int JOIN XMLELEM$OPEN 100 34 30 50 33 6 0.184 650 Int JOIN CTE$MSTMT 100 35 30 50 33 7 0.207 650 Int JOIN ITER$SIMPLE 100 40 30 50 46 7 0.185 650 Int JOIN EXEC$A 100 86 76 96 93 8 0.091 650 Int JOIN MANYUNION 100 316 296 330 313 10 0.031 650 Int JOIN MANYINSERT 100 466 420 516 453 34 0.073 650 Int JOIN REALSLOW 2 40811 40750 40873 40811 87 0.002 650 Int JOIN SLOW$LIKE 2 50976 50813 51140 50976 231 0.005 650 Str UNPACK FIX$SINGLE 100 5 0 16 0 7 1.493 650 Str UNPACK CLR$SPLIT 100 6 0 16 0 8 1.266 650 Str UNPACK FIX$MULTI 100 6 0 16 0 8 1.266 650 Str UNPACK CLR$FIX 100 7 0 16 13 8 1.087 650 Str UNPACK CLR$ITER 100 7 0 16 13 8 1.095 650 Str UNPACK FIX$MULTI2 100 7 0 16 0 8 1.083 650 Str UNPACK FIX$MSTMT 100 9 0 16 13 7 0.825 650 Str UNPACK TBLNUM 100 11 0 16 16 7 0.599 650 Str UNPACK TBLNUM$DUO 100 12 0 16 16 6 0.486 650 Str UNPACK XMLATTR 100 12 0 16 16 6 0.471 650 Str UNPACK XMLATTR$STR 100 17 13 33 16 6 0.335 650 Str UNPACK XMLELEM 100 18 13 33 16 6 0.351 650 Str UNPACK TBLNUM$IL 100 19 13 33 16 8 0.396 650 Str UNPACK TBLNUM$ILOLD 100 19 13 33 16 8 0.398 650 Str UNPACK CTE$CHUNK 100 21 13 33 16 8 0.381 650 Str UNPACK TBLNUM$NOCNV 100 21 13 33 16 8 0.382 650 Str UNPACK CTE$IL 100 22 13 33 16 8 0.373 650 Str UNPACK FIX$ITER 100 25 13 33 30 8 0.308 650 Str UNPACK TBLNUM$NOBIN 100 25 13 33 30 8 0.307 650 Str UNPACK ITER$CHUNK 100 26 13 33 30 7 0.275 650 Str UNPACK XMLATTR$OPEN 100 28 13 33 30 6 0.229 650 Str UNPACK XMLELEM$OPEN 100 28 13 46 30 6 0.232 650 Str UNPACK CTE$MSTMT 100 31 30 33 30 1 0.048 650 Str UNPACK ITER$SIMPLE 100 31 30 46 30 4 0.124 650 Str UNPACK MANYSELECT 100 44 30 50 46 5 0.109 650 Str UNPACK MANYINSERT 100 531 483 580 516 34 0.064 650 Str UNPACK MANYUNION 100 885 843 923 890 16 0.019 650 Str JOIN EXEC$B 100 12 0 16 16 6 0.507 650 Str JOIN FIX$SINGLE 100 15 13 33 16 3 0.231 650 Str JOIN CLR$FIX 100 18 13 33 16 7 0.395 650 Str JOIN CLR$ITER 100 19 13 33 16 7 0.365 650 Str JOIN CLR$SPLIT 100 19 13 33 16 7 0.363 650 Str JOIN FIX$MULTI 100 19 13 33 16 7 0.389 650 Str JOIN FIX$MULTI2 100 19 13 33 16 7 0.362 650 Str JOIN FIX$MSTMT 100 20 13 33 16 8 0.385 650 Str JOIN FIX$TMPTBL 100 20 13 33 16 8 0.393 650 Str JOIN TBLNUM 100 21 13 33 16 8 0.378 650 Str JOIN XMLATTR 100 24 13 33 30 8 0.345 650 Str JOIN TBLNUM$DUO 100 25 13 33 30 8 0.304 650 Str JOIN XMLATTR$TMPTBL 100 25 13 33 30 7 0.297 650 Str JOIN XMLATTR$TVAR 100 26 13 33 30 8 0.296 650 Str JOIN XMLATTR$STR 100 30 13 33 30 4 0.142 650 Str JOIN CTE$CHUNK 100 32 30 50 30 5 0.155 650 Str JOIN TBLNUM$IL 100 32 30 50 30 5 0.145 650 Str JOIN TBLNUM$NOCNV 100 32 30 50 30 4 0.125 650 Str JOIN XMLELEM 100 32 30 46 31 4 0.110 650 Str JOIN CTE$IL 100 33 30 50 30 6 0.169 650 Str JOIN TBLNUM$ILOLD 100 33 30 50 30 6 0.185 650 Str JOIN FIX$ITER 100 37 30 50 33 8 0.213 650 Str JOIN ITER$CHUNK 100 38 30 50 33 8 0.207 650 Str JOIN TBLNUM$NOBIN 100 38 30 50 33 8 0.205 650 Str JOIN XMLATTR$OPEN 100 40 30 50 46 7 0.185 650 Str JOIN XMLELEM$OPEN 100 41 30 50 46 8 0.187 650 Str JOIN CTE$MSTMT 100 42 30 50 46 7 0.161 650 Str JOIN ITER$SIMPLE 100 43 30 50 46 6 0.143 650 Str JOIN MANYSELECT 100 56 46 63 63 8 0.144 650 Str JOIN EXEC$A 100 139 123 153 140 4 0.029 650 Str JOIN MANYINSERT 100 555 500 640 563 40 0.072 650 Str JOIN MANYUNION 100 897 856 936 893 18 0.020 650 Str JOIN REALSLOW 2 727178 723093 731263 727178 5777 0.008 650 Str JOIN SLOW$LIKE 2 755188 753064 757313 755188 3004 0.004 ------------------------------------------------------------------------------ 2000 Int UNPACK FIX$BINARY 100 15 13 33 16 2 0.152 2000 Int UNPACK FIX$SINGLE 100 16 13 33 16 4 0.279 2000 Int UNPACK FIX$MULTI 100 18 13 33 16 6 0.358 2000 Int UNPACK CLR$FIX 100 19 13 33 16 7 0.382 2000 Int UNPACK CLR$SPLIT 100 19 13 33 16 8 0.402 2000 Int UNPACK FIX$MULTI2 100 20 13 33 16 8 0.396 2000 Int UNPACK CLR$ITER 100 21 13 33 16 8 0.371 2000 Int UNPACK FIX$MSTMT 100 30 13 33 30 4 0.145 2000 Int UNPACK TBLNUM 100 30 13 46 30 4 0.144 2000 Int UNPACK TBLNUM$DUO 100 35 30 50 33 7 0.196 2000 Int UNPACK XMLATTR 100 35 30 50 33 7 0.209 2000 Int UNPACK TBLNUM$IL 100 47 43 63 46 4 0.081 2000 Int UNPACK TBLNUM$ILOLD 100 47 43 63 46 5 0.100 2000 Int UNPACK TBLNUM$NOCNV 100 48 43 63 46 6 0.117 2000 Int UNPACK XMLATTR$STR 100 48 43 63 46 6 0.120 2000 Int UNPACK XMLELEM 100 55 46 63 60 8 0.140 2000 Int UNPACK TBLNUM$NOBIN 100 62 46 80 63 3 0.049 2000 Int UNPACK CTE$CHUNK 100 63 60 80 63 5 0.077 2000 Int UNPACK CTE$IL 100 68 60 80 63 8 0.114 2000 Int UNPACK MANYSELECT 100 76 60 80 76 5 0.061 2000 Int UNPACK FIX$ITER 100 78 76 96 76 4 0.048 2000 Int UNPACK ITER$CHUNK 100 81 76 96 80 7 0.092 2000 Int UNPACK CTE$MSTMT 100 86 76 96 93 8 0.093 2000 Int UNPACK XMLATTR$OPEN 100 87 76 96 93 8 0.092 2000 Int UNPACK XMLELEM$OPEN 100 91 76 110 93 6 0.065 2000 Int UNPACK ITER$SIMPLE 100 111 106 126 110 6 0.050 2000 Int UNPACK MANYINSERT 100 1319 1283 1500 1296 54 0.041 2000 Int UNPACK MANYUNION 18 4797 4670 5000 4779 101 0.021 2000 Int JOIN EXEC$B 100 19 13 33 16 7 0.368 2000 Int JOIN FIX$MULTI2 100 25 13 33 30 8 0.302 2000 Int JOIN FIX$MULTI 100 27 13 46 30 9 0.325 2000 Int JOIN FIX$BINARY 100 31 30 50 30 3 0.111 2000 Int JOIN CLR$FIX 100 32 30 46 30 5 0.165 2000 Int JOIN CLR$SPLIT 100 32 30 50 30 5 0.160 2000 Int JOIN FIX$SINGLE 100 32 30 50 30 5 0.161 2000 Int JOIN CLR$ITER 100 33 30 46 30 5 0.156 2000 Int JOIN FIX$TMPTBL 100 34 30 50 33 7 0.196 2000 Int JOIN TBLNUM 100 39 30 50 46 8 0.194 2000 Int JOIN FIX$MSTMT 100 41 30 50 46 7 0.178 2000 Int JOIN TBLNUM$DUO 100 41 30 50 46 7 0.175 2000 Int JOIN XMLATTR 100 45 33 50 46 2 0.041 2000 Int JOIN XMLATTR$TVAR 100 51 43 63 46 8 0.155 2000 Int JOIN XMLATTR$TMPTBL 100 52 43 76 46 8 0.158 2000 Int JOIN TBLNUM$IL 100 55 43 63 60 8 0.147 2000 Int JOIN TBLNUM$ILOLD 100 58 43 76 63 8 0.129 2000 Int JOIN XMLATTR$STR 100 59 43 63 63 6 0.110 2000 Int JOIN XMLELEM 100 65 60 80 63 6 0.098 2000 Int JOIN TBLNUM$NOCNV 100 69 60 80 63 8 0.118 2000 Int JOIN TBLNUM$NOBIN 100 70 60 80 76 8 0.116 2000 Int JOIN CTE$CHUNK 100 74 60 93 76 7 0.096 2000 Int JOIN CTE$IL 100 83 76 96 80 8 0.095 2000 Int JOIN MANYSELECT 100 87 76 96 93 7 0.086 2000 Int JOIN FIX$ITER 100 88 76 96 93 8 0.086 2000 Int JOIN ITER$CHUNK 100 93 90 110 93 3 0.030 2000 Int JOIN CTE$MSTMT 100 96 90 110 93 7 0.069 2000 Int JOIN XMLATTR$OPEN 100 104 90 110 110 7 0.072 2000 Int JOIN XMLELEM$OPEN 100 108 90 110 110 5 0.044 2000 Int JOIN ITER$SIMPLE 100 124 106 436 123 32 0.258 2000 Int JOIN EXEC$A 100 333 326 346 330 8 0.023 2000 Int JOIN MANYINSERT 100 1327 1296 1516 1313 48 0.037 2000 Int JOIN MANYUNION 19 4822 4686 4986 4813 101 0.021 2000 Str UNPACK FIX$SINGLE 100 18 13 33 16 6 0.346 2000 Str UNPACK FIX$MULTI 100 20 13 33 16 8 0.406 2000 Str UNPACK FIX$MULTI2 100 22 13 46 16 8 0.380 2000 Str UNPACK CLR$ITER 100 23 13 46 30 8 0.357 2000 Str UNPACK CLR$SPLIT 100 23 13 33 30 8 0.358 2000 Str UNPACK CLR$FIX 100 24 13 33 30 8 0.335 2000 Str UNPACK FIX$MSTMT 100 31 13 46 30 3 0.103 2000 Str UNPACK TBLNUM 100 32 30 50 30 4 0.132 2000 Str UNPACK TBLNUM$DUO 100 38 30 50 33 8 0.201 2000 Str UNPACK XMLATTR 100 38 30 50 33 8 0.201 2000 Str UNPACK XMLATTR$STR 100 52 43 63 46 8 0.152 2000 Str UNPACK XMLELEM 100 56 43 63 60 8 0.137 2000 Str UNPACK TBLNUM$IL 100 61 46 76 63 5 0.075 2000 Str UNPACK TBLNUM$ILOLD 100 62 60 80 63 3 0.049 2000 Str UNPACK CTE$CHUNK 100 64 60 80 63 6 0.090 2000 Str UNPACK TBLNUM$NOCNV 100 66 60 80 63 7 0.101 2000 Str UNPACK CTE$IL 100 68 60 93 63 8 0.120 2000 Str UNPACK FIX$ITER 100 79 76 96 76 5 0.065 2000 Str UNPACK TBLNUM$NOBIN 100 80 76 96 76 7 0.082 2000 Str UNPACK ITER$CHUNK 100 81 76 96 80 7 0.081 2000 Str UNPACK CTE$MSTMT 100 86 76 96 93 8 0.094 2000 Str UNPACK XMLATTR$OPEN 100 88 76 110 93 8 0.088 2000 Str UNPACK XMLELEM$OPEN 100 91 76 96 93 5 0.058 2000 Str UNPACK ITER$SIMPLE 100 97 93 110 93 7 0.074 2000 Str UNPACK MANYSELECT 100 136 123 153 140 7 0.055 2000 Str UNPACK MANYINSERT 100 1566 1500 1783 1516 84 0.054 2000 Str UNPACK MANYUNION 18 11533 11343 11736 11561 131 0.011 2000 Str JOIN EXEC$B 100 42 30 60 46 7 0.177 2000 Str JOIN FIX$MULTI 100 48 43 63 46 6 0.127 2000 Str JOIN FIX$MULTI2 100 48 43 63 46 6 0.119 2000 Str JOIN FIX$SINGLE 100 49 43 63 46 7 0.134 2000 Str JOIN FIX$TMPTBL 100 57 43 80 63 8 0.137 2000 Str JOIN CLR$ITER 100 58 43 76 63 7 0.129 2000 Str JOIN CLR$SPLIT 100 58 43 63 63 7 0.123 2000 Str JOIN CLR$FIX 100 59 43 63 63 6 0.109 2000 Str JOIN FIX$MSTMT 100 63 60 80 63 5 0.072 2000 Str JOIN TBLNUM 100 65 60 80 63 6 0.098 2000 Str JOIN XMLATTR 100 70 60 93 76 8 0.120 2000 Str JOIN TBLNUM$DUO 100 71 60 80 76 8 0.109 2000 Str JOIN TBLNUM$IL 100 73 60 80 76 7 0.098 2000 Str JOIN TBLNUM$ILOLD 100 75 60 80 76 6 0.080 2000 Str JOIN XMLATTR$TVAR 100 76 60 93 76 5 0.071 2000 Str JOIN XMLATTR$TMPTBL 100 77 63 93 76 3 0.038 2000 Str JOIN XMLATTR$STR 100 84 76 96 80 8 0.094 2000 Str JOIN TBLNUM$NOBIN 100 87 76 96 93 8 0.089 2000 Str JOIN XMLELEM 100 89 76 110 93 8 0.085 2000 Str JOIN CTE$CHUNK 100 96 90 110 93 7 0.071 2000 Str JOIN TBLNUM$NOCNV 100 98 90 126 93 8 0.083 2000 Str JOIN CTE$IL 100 99 93 123 93 8 0.079 2000 Str JOIN FIX$ITER 100 113 106 126 110 7 0.059 2000 Str JOIN ITER$CHUNK 100 113 106 126 110 7 0.059 2000 Str JOIN CTE$MSTMT 100 119 106 126 123 7 0.061 2000 Str JOIN XMLATTR$OPEN 100 126 123 140 126 5 0.042 2000 Str JOIN XMLELEM$OPEN 100 129 123 143 126 8 0.060 2000 Str JOIN ITER$SIMPLE 100 130 123 156 126 8 0.063 2000 Str JOIN MANYSELECT 100 168 153 186 171 7 0.044 2000 Str JOIN EXEC$A 100 499 483 530 500 6 0.013 2000 Str JOIN MANYINSERT 100 1620 1530 1796 1586 78 0.048 2000 Str JOIN MANYUNION 18 11574 11360 11800 11546 112 0.010 ------------------------------------------------------------------------------ 10000 Int UNPACK FIX$BINARY 100 70 60 80 76 8 0.112 10000 Int UNPACK FIX$SINGLE 100 71 60 80 76 8 0.112 10000 Int UNPACK FIX$MULTI 100 83 76 96 80 8 0.095 10000 Int UNPACK FIX$MULTI2 100 86 76 96 93 8 0.090 10000 Int UNPACK CLR$FIX 100 95 90 110 93 6 0.064 10000 Int UNPACK CLR$SPLIT 100 97 90 110 93 7 0.073 10000 Int UNPACK CLR$ITER 100 99 90 110 93 8 0.081 10000 Int UNPACK FIX$MSTMT 100 130 123 233 126 13 0.098 10000 Int UNPACK TBLNUM 100 132 123 436 126 38 0.288 10000 Int UNPACK TBLNUM$DUO 100 146 140 160 143 8 0.054 10000 Int UNPACK XMLATTR 100 169 153 186 170 7 0.039 10000 Int UNPACK TBLNUM$IL 100 230 216 250 233 7 0.031 10000 Int UNPACK TBLNUM$ILOLD 100 235 216 343 233 12 0.051 10000 Int UNPACK TBLNUM$NOCNV 100 238 233 253 236 8 0.032 10000 Int UNPACK XMLATTR$STR 100 239 233 266 236 9 0.036 10000 Int UNPACK XMLELEM 100 272 263 283 266 8 0.029 10000 Int UNPACK TBLNUM$NOBIN 100 297 280 313 296 6 0.020 10000 Int UNPACK CTE$CHUNK 100 310 296 330 313 7 0.022 10000 Int UNPACK CTE$IL 100 330 326 346 330 6 0.018 10000 Int UNPACK MANYSELECT 100 391 390 406 390 4 0.011 10000 Int UNPACK CTE$MSTMT 100 392 376 420 390 6 0.016 10000 Int UNPACK FIX$ITER 100 394 373 656 390 47 0.119 10000 Int UNPACK ITER$CHUNK 100 406 390 656 406 36 0.088 10000 Int UNPACK XMLATTR$OPEN 100 439 420 453 436 7 0.016 10000 Int UNPACK XMLELEM$OPEN 100 458 450 483 453 8 0.017 10000 Int UNPACK ITER$SIMPLE 100 548 530 656 546 12 0.023 10000 Int UNPACK MANYINSERT 2 6601 6593 6610 6601 12 0.002 10000 Int UNPACK MANYUNION 2 176834 176123 177546 176834 1006 0.006 10000 Int JOIN FIX$MULTI 100 105 90 143 110 12 0.118 10000 Int JOIN FIX$MULTI2 100 105 90 326 106 25 0.234 10000 Int JOIN CLR$FIX 100 142 123 283 140 15 0.104 10000 Int JOIN CLR$ITER 100 142 140 160 140 5 0.035 10000 Int JOIN CLR$SPLIT 100 144 140 250 140 12 0.085 10000 Int JOIN FIX$BINARY 100 148 140 160 148 8 0.052 10000 Int JOIN FIX$SINGLE 100 151 140 160 156 7 0.045 10000 Int JOIN TBLNUM 100 177 170 190 173 8 0.043 10000 Int JOIN FIX$MSTMT 100 179 170 203 186 8 0.047 10000 Int JOIN TBLNUM$IL 100 192 170 216 190 10 0.050 10000 Int JOIN TBLNUM$DUO 100 193 186 206 190 8 0.042 10000 Int JOIN TBLNUM$ILOLD 100 201 186 220 203 10 0.052 10000 Int JOIN XMLATTR 100 208 200 233 203 8 0.037 10000 Int JOIN TBLNUM$NOBIN 100 224 200 250 220 11 0.049 10000 Int JOIN XMLATTR$TVAR 100 251 250 266 250 4 0.017 10000 Int JOIN XMLATTR$STR 100 278 263 296 280 7 0.024 10000 Int JOIN XMLELEM 100 304 293 326 303 8 0.028 10000 Int JOIN TBLNUM$NOCNV 100 328 310 346 330 6 0.019 10000 Int JOIN CTE$CHUNK 100 358 343 373 360 5 0.013 10000 Int JOIN CTE$IL 100 410 403 436 406 8 0.019 10000 Int JOIN EXEC$B 99 415 340 3530 356 449 1.081 10000 Int JOIN FIX$TMPTBL 100 418 403 440 420 10 0.023 10000 Int JOIN FIX$ITER 100 441 420 703 436 42 0.094 10000 Int JOIN CTE$MSTMT 100 443 436 456 440 8 0.019 10000 Int JOIN ITER$CHUNK 100 459 436 703 453 40 0.087 10000 Int JOIN XMLATTR$TMPTBL 100 511 500 533 513 9 0.017 10000 Int JOIN XMLATTR$OPEN 100 523 513 546 516 9 0.017 10000 Int JOIN XMLELEM$OPEN 100 539 530 563 543 8 0.015 10000 Int JOIN ITER$SIMPLE 100 613 590 860 594 53 0.087 10000 Int JOIN MANYSELECT 100 701 686 720 703 7 0.010 10000 Int JOIN EXEC$A 100 3518 3470 3580 3516 17 0.005 10000 Int JOIN MANYINSERT 2 6944 6936 6953 6944 12 0.002 10000 Int JOIN MANYUNION 2 177571 177376 177766 177571 276 0.002 10000 Str UNPACK CLR$ITER 100 109 93 126 110 5 0.042 10000 Str UNPACK CLR$SPLIT 100 110 93 126 110 5 0.047 10000 Str UNPACK CLR$FIX 100 115 106 126 110 8 0.067 10000 Str UNPACK TBLNUM 100 147 140 406 140 34 0.234 10000 Str UNPACK TBLNUM$DUO 100 167 153 376 170 23 0.135 10000 Str UNPACK XMLATTR 100 178 170 203 173 8 0.046 10000 Str UNPACK FIX$SINGLE 100 179 170 190 186 8 0.042 10000 Str UNPACK FIX$MULTI 100 192 170 250 186 10 0.051 10000 Str UNPACK FIX$MSTMT 100 236 233 250 233 6 0.027 10000 Str UNPACK FIX$MULTI2 100 241 233 266 236 9 0.036 10000 Str UNPACK XMLATTR$STR 100 252 250 406 250 16 0.063 10000 Str UNPACK XMLELEM 100 277 263 296 280 7 0.025 10000 Str UNPACK TBLNUM$IL 100 300 293 343 296 8 0.026 10000 Str UNPACK TBLNUM$NOCNV 100 312 296 330 313 5 0.016 10000 Str UNPACK CTE$CHUNK 100 316 296 610 313 30 0.095 10000 Str UNPACK CTE$IL 100 332 326 360 330 8 0.024 10000 Str UNPACK TBLNUM$NOBIN 100 396 390 423 390 8 0.021 10000 Str UNPACK CTE$MSTMT 100 397 390 530 390 15 0.039 10000 Str UNPACK ITER$CHUNK 100 399 373 640 390 40 0.101 10000 Str UNPACK XMLATTR$OPEN 100 438 420 456 436 7 0.016 10000 Str UNPACK XMLELEM$OPEN 100 457 450 486 453 8 0.017 10000 Str UNPACK ITER$SIMPLE 100 486 466 720 483 29 0.060 10000 Str UNPACK TBLNUM$ILOLD 100 512 496 546 516 8 0.016 10000 Str UNPACK FIX$ITER 100 514 500 703 516 20 0.040 10000 Str UNPACK MANYSELECT 100 904 890 923 906 8 0.009 10000 Str UNPACK MANYINSERT 2 7631 7623 7640 7631 12 0.002 10000 Str UNPACK MANYUNION 2 371813 371516 372110 371813 420 0.001 10000 Str JOIN EXEC$B 99 156 153 173 156 5 0.029 10000 Str JOIN CLR$ITER 100 230 216 470 233 25 0.110 10000 Str JOIN CLR$SPLIT 100 233 216 470 233 25 0.106 10000 Str JOIN CLR$FIX 100 234 216 250 233 5 0.021 10000 Str JOIN TBLNUM 100 273 263 436 266 22 0.080 10000 Str JOIN TBLNUM$IL 100 281 250 596 280 37 0.133 10000 Str JOIN XMLATTR 100 287 280 313 283 8 0.028 10000 Str JOIN TBLNUM$DUO 100 289 280 310 296 8 0.027 10000 Str JOIN FIX$MULTI 100 297 280 330 296 12 0.040 10000 Str JOIN FIX$SINGLE 100 299 293 326 296 7 0.024 10000 Str JOIN TBLNUM$ILOLD 100 307 280 420 300 21 0.067 10000 Str JOIN TBLNUM$NOBIN 100 330 310 423 326 21 0.063 10000 Str JOIN XMLATTR$TVAR 100 338 326 406 343 10 0.031 10000 Str JOIN FIX$TMPTBL 100 344 326 610 343 28 0.080 10000 Str JOIN XMLATTR$TMPTBL 100 344 326 470 343 18 0.053 10000 Str JOIN FIX$MULTI2 100 348 326 376 343 14 0.040 10000 Str JOIN XMLATTR$STR 100 359 356 376 360 4 0.010 10000 Str JOIN FIX$MSTMT 100 365 356 376 360 7 0.020 10000 Str JOIN XMLELEM 100 383 373 406 390 8 0.022 10000 Str JOIN TBLNUM$NOCNV 100 437 420 453 436 6 0.014 10000 Str JOIN CTE$CHUNK 100 439 436 456 436 7 0.015 10000 Str JOIN CTE$IL 100 440 423 456 436 7 0.016 10000 Str JOIN ITER$CHUNK 100 520 513 733 516 23 0.043 10000 Str JOIN CTE$MSTMT 100 524 513 593 530 13 0.024 10000 Str JOIN XMLATTR$OPEN 100 584 576 610 580 8 0.014 10000 Str JOIN XMLELEM$OPEN 100 598 590 626 593 9 0.014 10000 Str JOIN ITER$SIMPLE 100 623 593 890 610 55 0.088 10000 Str JOIN FIX$ITER 100 647 623 910 640 41 0.064 10000 Str JOIN MANYSELECT 100 1035 1013 1063 1033 10 0.009 10000 Str JOIN EXEC$A 100 4267 4220 4296 4266 15 0.003 10000 Str JOIN MANYINSERT 2 7798 7783 7813 7798 21 0.003 10000 Str JOIN MANYUNION 2 372306 372016 372596 372306 410 0.001