Size Data Optype Method Cnt Avg Min Max Median Stdev Varcoeff ---- ---- ------ ------ --- --- --- --- ------ ----- -------- 20 Int JOIN CLR$ITER 10 0 0 0 0 0 0.000 20 Int JOIN CTE$IL 10 0 0 0 0 0 0.000 20 Int JOIN TBLNUM$IL 10 0 0 0 0 0 0.000 20 Int JOIN EXEC$A 10 1 0 16 0 5 5.060 20 Int JOIN EXEC$B 10 1 0 16 0 5 5.060 20 Int JOIN MANYSELECT 10 1 0 13 0 4 4.111 20 Int JOIN XMLATTR 10 1 0 16 0 5 5.060 20 Int JOIN FIX$SINGLE 10 2 0 16 0 6 3.077 20 Int JOIN MANYUNION 10 2 0 16 0 6 3.077 20 Int JOIN MANYINSERT 10 27 13 33 30 7 0.252 20 Str JOIN CTE$IL 10 1 0 16 0 5 5.060 20 Str JOIN EXEC$A 10 1 0 16 0 5 5.060 20 Str JOIN EXEC$B 10 1 0 13 0 4 4.111 20 Str JOIN TBLNUM$IL 10 1 0 16 0 5 5.060 20 Str JOIN XMLATTR 10 3 0 16 0 7 2.249 20 Str JOIN FIX$SINGLE 10 4 0 16 0 8 1.932 20 Str JOIN MANYSELECT 10 4 0 16 0 7 1.823 20 Str JOIN MANYUNION 10 7 0 16 6 8 1.125 20 Str JOIN MANYINSERT 10 31 30 33 30 2 0.050 20 Str JOIN CLR$ITER 10 103 76 140 93 21 0.208 ------------------------------------------------------------------------------ 200 Int JOIN EXEC$B 10 1 0 16 0 5 5.060 200 Int JOIN FIX$SINGLE 10 2 0 16 0 6 3.077 200 Int JOIN CLR$ITER 10 3 0 16 0 7 2.249 200 Int JOIN EXEC$A 10 4 0 16 0 8 1.932 200 Int JOIN XMLATTR 10 4 0 16 0 8 1.932 200 Int JOIN CTE$IL 10 7 0 16 6 8 1.125 200 Int JOIN TBLNUM$IL 10 7 0 16 6 8 1.167 200 Int JOIN MANYSELECT 10 11 0 16 13 6 0.556 200 Int JOIN MANYUNION 10 40 30 46 44 7 0.174 200 Int JOIN MANYINSERT 10 274 263 283 280 8 0.031 200 Str JOIN FIX$SINGLE 10 4 0 16 0 7 1.823 200 Str JOIN EXEC$B 10 6 0 16 0 8 1.377 200 Str JOIN CTE$IL 10 7 0 16 6 8 1.125 200 Str JOIN XMLATTR 10 7 0 16 6 8 1.167 200 Str JOIN EXEC$A 10 12 0 16 16 7 0.555 200 Str JOIN TBLNUM$IL 10 12 0 16 16 7 0.545 200 Str JOIN MANYSELECT 10 14 13 16 14 2 0.113 200 Str JOIN MANYUNION 10 104 93 110 110 8 0.077 200 Str JOIN CLR$ITER 10 188 30 513 133 156 0.830 200 Str JOIN MANYINSERT 10 319 313 330 313 8 0.026 ------------------------------------------------------------------------------ 650 Int JOIN EXEC$B 10 10 0 16 13 7 0.702 650 Int JOIN CLR$ITER 10 12 0 16 16 7 0.555 650 Int JOIN FIX$SINGLE 10 12 0 16 16 7 0.545 650 Int JOIN XMLATTR 10 14 13 16 16 2 0.111 650 Int JOIN EXEC$A 10 16 13 30 16 5 0.309 650 Int JOIN TBLNUM$IL 10 17 13 33 16 7 0.432 650 Int JOIN CTE$IL 10 31 30 33 31 2 0.051 650 Int JOIN MANYSELECT 10 31 30 33 33 2 0.050 650 Int JOIN MANYUNION 10 312 296 330 313 11 0.036 650 Int JOIN MANYINSERT 10 1106 1076 1143 1093 30 0.028 650 Str JOIN FIX$SINGLE 10 17 13 30 16 7 0.384 650 Str JOIN XMLATTR 10 22 13 33 23 8 0.384 650 Str JOIN EXEC$B 10 23 13 33 23 8 0.353 650 Str JOIN CLR$ITER 10 25 13 76 16 19 0.776 650 Str JOIN CTE$IL 10 34 30 46 31 6 0.189 650 Str JOIN EXEC$A 10 34 30 46 31 6 0.189 650 Str JOIN TBLNUM$IL 10 34 30 50 31 7 0.215 650 Str JOIN MANYSELECT 10 57 46 63 63 8 0.141 650 Str JOIN MANYUNION 10 907 890 923 906 12 0.013 650 Str JOIN MANYINSERT 10 1245 1216 1283 1233 26 0.021 ------------------------------------------------------------------------------ 2000 Int JOIN CLR$ITER 10 32 30 46 31 5 0.152 2000 Int JOIN FIX$SINGLE 10 32 30 46 30 5 0.155 2000 Int JOIN EXEC$B 10 37 30 50 33 8 0.228 2000 Int JOIN XMLATTR 10 46 46 50 46 1 0.027 2000 Int JOIN EXEC$A 10 56 46 63 61 8 0.145 2000 Int JOIN TBLNUM$IL 10 70 60 80 69 8 0.117 2000 Int JOIN CTE$IL 10 81 76 93 78 8 0.097 2000 Int JOIN MANYSELECT 10 91 76 96 93 6 0.061 2000 Int JOIN MANYUNION 10 4638 4560 4733 4631 53 0.011 2000 Int JOIN MANYINSERT 10 5361 5296 5420 5359 43 0.008 2000 Str JOIN EXEC$B 10 41 30 50 46 8 0.187 2000 Str JOIN FIX$SINGLE 10 52 46 63 46 8 0.155 2000 Str JOIN CLR$ITER 10 61 46 63 63 5 0.088 2000 Str JOIN XMLATTR 10 66 60 80 63 8 0.117 2000 Str JOIN EXEC$A 10 72 63 80 76 8 0.110 2000 Str JOIN TBLNUM$IL 10 96 90 110 93 6 0.067 2000 Str JOIN CTE$IL 10 106 93 110 110 6 0.060 2000 Str JOIN MANYSELECT 10 172 170 173 173 1 0.008 2000 Str JOIN MANYINSERT 10 5850 5733 5920 5858 55 0.009 2000 Str JOIN MANYUNION 10 11325 11140 11563 11319 140 0.012 ------------------------------------------------------------------------------ 10000 Int JOIN CLR$ITER 10 143 140 156 140 7 0.047 10000 Int JOIN FIX$SINGLE 10 151 140 156 154 6 0.043 10000 Int JOIN XMLATTR 10 209 203 216 209 7 0.033 10000 Int JOIN TBLNUM$IL 10 330 326 343 330 5 0.015 10000 Int JOIN EXEC$B 10 347 340 360 343 8 0.023 10000 Int JOIN CTE$IL 10 410 403 423 406 8 0.020 10000 Int JOIN MANYSELECT 10 707 703 736 703 11 0.015 10000 Int JOIN EXEC$A 10 3399 3326 3453 3419 48 0.014 10000 Int JOIN MANYINSERT 4 85362 84126 86186 85569 957 0.011 10000 Int JOIN MANYUNION 2 166274 165266 167283 166274 1426 0.009 10000 Str JOIN EXEC$B 10 155 153 156 156 1 0.009 10000 Str JOIN CLR$ITER 10 226 216 236 220 9 0.038 10000 Str JOIN XMLATTR 10 282 280 296 280 5 0.018 10000 Str JOIN FIX$SINGLE 10 296 296 300 296 2 0.006 10000 Str JOIN TBLNUM$IL 10 436 423 440 438 5 0.012 10000 Str JOIN CTE$IL 10 439 436 466 436 9 0.021 10000 Str JOIN MANYSELECT 10 1048 1046 1063 1046 5 0.005 10000 Str JOIN EXEC$A 10 4142 4063 4190 4166 46 0.011 10000 Str JOIN MANYINSERT 3 87454 85940 88766 87656 1424 0.016 10000 Str JOIN MANYUNION 2 361921 361576 362266 361921 488 0.001