=======BASELINE========= test is already loaded with 10000000 rows base table size: 346 MB create temporary table tmptest /* 5 cols */ (c1 int not null, c2 int not null, c3 int not null, c4 int not null, c5 int not null) insert into tmptest select /* 5 */ c1, c1, c1, c1, c1 from test tmp table size: 498 MB avg time = 4692.625 ms median 80% of the times (ms) = {4517, 4517, 4522, 4526, 4528, 4534, 4537, 4541, 4563, 4580, 4697, 4827, 5040, 5044, 5045, 5064} create temporary table tmptest /* 5 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null) insert into tmptest select /* 5 */ c1, c1, c1, c1, c1 from test tmp table size: 498 MB avg time = 4314.5 ms median 80% of the times (ms) = {4167, 4175, 4191, 4207, 4216, 4218, 4221, 4231, 4259, 4261, 4330, 4448, 4488, 4506, 4543, 4571} create temporary table tmptest /* 5 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 346 MB avg time = 4368.5 ms median 80% of the times (ms) = {4029, 4103, 4280, 4357, 4382, 4397, 4413, 4419, 4422, 4422, 4427, 4437, 4443, 4447, 4457, 4461} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 422 MB avg time = 8165.5 ms median 80% of the times (ms) = {7793, 7875, 7907, 7982, 8039, 8049, 8070, 8095, 8134, 8163, 8258, 8410, 8440, 8449, 8461, 8523} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 20 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 1116 MB avg time = 9380.9375 ms median 80% of the times (ms) = {9370, 9370, 9371, 9371, 9375, 9375, 9377, 9380, 9383, 9385, 9386, 9388, 9389, 9389, 9392, 9394} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 40 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 1906 MB avg time = 11654.3125 ms median 80% of the times (ms) = {11163, 11392, 11408, 11437, 11465, 11490, 11582, 11647, 11680, 11704, 11860, 11865, 11905, 11922, 11970, 11979} create temporary table tmptest /* 100 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 498 MB avg time = 13442.25 ms median 80% of the times (ms) = {13388, 13413, 13440, 13528} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 1347 MB avg time = 126837.25 ms median 80% of the times (ms) = {117274, 118301, 129310, 142464} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 50 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 3256 MB avg time = 132997.75 ms median 80% of the times (ms) = {129072, 131227, 135425, 136267} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 100 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 5210 MB avg time = 124580.5 ms median 80% of the times (ms) = {119217, 121609, 122928, 134568} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 200 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 9768 MB avg time = 174703.25 ms median 80% of the times (ms) = {168157, 173116, 178526, 179014} =======END: BASELINE========= =======PATCH========= test is already loaded with 10000000 rows base table size: 346 MB create temporary table tmptest /* 5 cols */ (c1 int not null, c2 int not null, c3 int not null, c4 int not null, c5 int not null) insert into tmptest select /* 5 */ c1, c1, c1, c1, c1 from test tmp table size: 498 MB avg time = 4352.375 ms median 80% of the times (ms) = {4323, 4328, 4331, 4331, 4337, 4344, 4346, 4356, 4358, 4358, 4358, 4360, 4361, 4381, 4382, 4384} create temporary table tmptest /* 5 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null) insert into tmptest select /* 5 */ c1, c1, c1, c1, c1 from test tmp table size: 498 MB avg time = 4056.75 ms median 80% of the times (ms) = {4041, 4043, 4046, 4048, 4048, 4049, 4051, 4054, 4055, 4057, 4061, 4065, 4066, 4073, 4074, 4077} create temporary table tmptest /* 5 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 346 MB avg time = 3865.5 ms median 80% of the times (ms) = {3844, 3846, 3850, 3851, 3853, 3853, 3854, 3859, 3861, 3862, 3865, 3868, 3892, 3893, 3898, 3899} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 346 MB avg time = 6717.625 ms median 80% of the times (ms) = {6682, 6683, 6687, 6695, 6695, 6710, 6714, 6718, 6723, 6727, 6734, 6735, 6740, 6745, 6746, 6748} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 20 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 1116 MB avg time = 8702.125 ms median 80% of the times (ms) = {8667, 8669, 8669, 8677, 8680, 8690, 8700, 8706, 8712, 8716, 8720, 8723, 8723, 8724, 8725, 8733} create temporary table tmptest /* 50 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null) insert into tmptest select /* 40 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 1906 MB avg time = 11288.1875 ms median 80% of the times (ms) = {10838, 10929, 10932, 10936, 11053, 11094, 11176, 11237, 11266, 11357, 11374, 11436, 11663, 11689, 11784, 11847} create temporary table tmptest /* 100 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 346 MB avg time = 11416.0 ms median 80% of the times (ms) = {11315, 11342, 11497, 11510} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 1 */ c1 from test tmp table size: 346 MB avg time = 104255.5 ms median 80% of the times (ms) = {103511, 104355, 104389, 104767} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 50 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 2298 MB avg time = 105708.5 ms median 80% of the times (ms) = {105510, 105557, 105738, 106029} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 100 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 4341 MB avg time = 118425.25 ms median 80% of the times (ms) = {116077, 118484, 118546, 120594} create temporary table tmptest /* 800 cols */ (c1 int null, c2 int null, c3 int null, c4 int null, c5 int null, c6 int null, c7 int null, c8 int null, c9 int null, c10 int null, c11 int null, c12 int null, c13 int null, c14 int null, c15 int null, c16 int null, c17 int null, c18 int null, c19 int null, c20 int null, c21 int null, c22 int null, c23 int null, c24 int null, c25 int null, c26 int null, c27 int null, c28 int null, c29 int null, c30 int null, c31 int null, c32 int null, c33 int null, c34 int null, c35 int null, c36 int null, c37 int null, c38 int null, c39 int null, c40 int null, c41 int null, c42 int null, c43 int null, c44 int null, c45 int null, c46 int null, c47 int null, c48 int null, c49 int null, c50 int null, c51 int null, c52 int null, c53 int null, c54 int null, c55 int null, c56 int null, c57 int null, c58 int null, c59 int null, c60 int null, c61 int null, c62 int null, c63 int null, c64 int null, c65 int null, c66 int null, c67 int null, c68 int null, c69 int null, c70 int null, c71 int null, c72 int null, c73 int null, c74 int null, c75 int null, c76 int null, c77 int null, c78 int null, c79 int null, c80 int null, c81 int null, c82 int null, c83 int null, c84 int null, c85 int null, c86 int null, c87 int null, c88 int null, c89 int null, c90 int null, c91 int null, c92 int null, c93 int null, c94 int null, c95 int null, c96 int null, c97 int null, c98 int null, c99 int null, c100 int null, c101 int null, c102 int null, c103 int null, c104 int null, c105 int null, c106 int null, c107 int null, c108 int null, c109 int null, c110 int null, c111 int null, c112 int null, c113 int null, c114 int null, c115 int null, c116 int null, c117 int null, c118 int null, c119 int null, c120 int null, c121 int null, c122 int null, c123 int null, c124 int null, c125 int null, c126 int null, c127 int null, c128 int null, c129 int null, c130 int null, c131 int null, c132 int null, c133 int null, c134 int null, c135 int null, c136 int null, c137 int null, c138 int null, c139 int null, c140 int null, c141 int null, c142 int null, c143 int null, c144 int null, c145 int null, c146 int null, c147 int null, c148 int null, c149 int null, c150 int null, c151 int null, c152 int null, c153 int null, c154 int null, c155 int null, c156 int null, c157 int null, c158 int null, c159 int null, c160 int null, c161 int null, c162 int null, c163 int null, c164 int null, c165 int null, c166 int null, c167 int null, c168 int null, c169 int null, c170 int null, c171 int null, c172 int null, c173 int null, c174 int null, c175 int null, c176 int null, c177 int null, c178 int null, c179 int null, c180 int null, c181 int null, c182 int null, c183 int null, c184 int null, c185 int null, c186 int null, c187 int null, c188 int null, c189 int null, c190 int null, c191 int null, c192 int null, c193 int null, c194 int null, c195 int null, c196 int null, c197 int null, c198 int null, c199 int null, c200 int null, c201 int null, c202 int null, c203 int null, c204 int null, c205 int null, c206 int null, c207 int null, c208 int null, c209 int null, c210 int null, c211 int null, c212 int null, c213 int null, c214 int null, c215 int null, c216 int null, c217 int null, c218 int null, c219 int null, c220 int null, c221 int null, c222 int null, c223 int null, c224 int null, c225 int null, c226 int null, c227 int null, c228 int null, c229 int null, c230 int null, c231 int null, c232 int null, c233 int null, c234 int null, c235 int null, c236 int null, c237 int null, c238 int null, c239 int null, c240 int null, c241 int null, c242 int null, c243 int null, c244 int null, c245 int null, c246 int null, c247 int null, c248 int null, c249 int null, c250 int null, c251 int null, c252 int null, c253 int null, c254 int null, c255 int null, c256 int null, c257 int null, c258 int null, c259 int null, c260 int null, c261 int null, c262 int null, c263 int null, c264 int null, c265 int null, c266 int null, c267 int null, c268 int null, c269 int null, c270 int null, c271 int null, c272 int null, c273 int null, c274 int null, c275 int null, c276 int null, c277 int null, c278 int null, c279 int null, c280 int null, c281 int null, c282 int null, c283 int null, c284 int null, c285 int null, c286 int null, c287 int null, c288 int null, c289 int null, c290 int null, c291 int null, c292 int null, c293 int null, c294 int null, c295 int null, c296 int null, c297 int null, c298 int null, c299 int null, c300 int null, c301 int null, c302 int null, c303 int null, c304 int null, c305 int null, c306 int null, c307 int null, c308 int null, c309 int null, c310 int null, c311 int null, c312 int null, c313 int null, c314 int null, c315 int null, c316 int null, c317 int null, c318 int null, c319 int null, c320 int null, c321 int null, c322 int null, c323 int null, c324 int null, c325 int null, c326 int null, c327 int null, c328 int null, c329 int null, c330 int null, c331 int null, c332 int null, c333 int null, c334 int null, c335 int null, c336 int null, c337 int null, c338 int null, c339 int null, c340 int null, c341 int null, c342 int null, c343 int null, c344 int null, c345 int null, c346 int null, c347 int null, c348 int null, c349 int null, c350 int null, c351 int null, c352 int null, c353 int null, c354 int null, c355 int null, c356 int null, c357 int null, c358 int null, c359 int null, c360 int null, c361 int null, c362 int null, c363 int null, c364 int null, c365 int null, c366 int null, c367 int null, c368 int null, c369 int null, c370 int null, c371 int null, c372 int null, c373 int null, c374 int null, c375 int null, c376 int null, c377 int null, c378 int null, c379 int null, c380 int null, c381 int null, c382 int null, c383 int null, c384 int null, c385 int null, c386 int null, c387 int null, c388 int null, c389 int null, c390 int null, c391 int null, c392 int null, c393 int null, c394 int null, c395 int null, c396 int null, c397 int null, c398 int null, c399 int null, c400 int null, c401 int null, c402 int null, c403 int null, c404 int null, c405 int null, c406 int null, c407 int null, c408 int null, c409 int null, c410 int null, c411 int null, c412 int null, c413 int null, c414 int null, c415 int null, c416 int null, c417 int null, c418 int null, c419 int null, c420 int null, c421 int null, c422 int null, c423 int null, c424 int null, c425 int null, c426 int null, c427 int null, c428 int null, c429 int null, c430 int null, c431 int null, c432 int null, c433 int null, c434 int null, c435 int null, c436 int null, c437 int null, c438 int null, c439 int null, c440 int null, c441 int null, c442 int null, c443 int null, c444 int null, c445 int null, c446 int null, c447 int null, c448 int null, c449 int null, c450 int null, c451 int null, c452 int null, c453 int null, c454 int null, c455 int null, c456 int null, c457 int null, c458 int null, c459 int null, c460 int null, c461 int null, c462 int null, c463 int null, c464 int null, c465 int null, c466 int null, c467 int null, c468 int null, c469 int null, c470 int null, c471 int null, c472 int null, c473 int null, c474 int null, c475 int null, c476 int null, c477 int null, c478 int null, c479 int null, c480 int null, c481 int null, c482 int null, c483 int null, c484 int null, c485 int null, c486 int null, c487 int null, c488 int null, c489 int null, c490 int null, c491 int null, c492 int null, c493 int null, c494 int null, c495 int null, c496 int null, c497 int null, c498 int null, c499 int null, c500 int null, c501 int null, c502 int null, c503 int null, c504 int null, c505 int null, c506 int null, c507 int null, c508 int null, c509 int null, c510 int null, c511 int null, c512 int null, c513 int null, c514 int null, c515 int null, c516 int null, c517 int null, c518 int null, c519 int null, c520 int null, c521 int null, c522 int null, c523 int null, c524 int null, c525 int null, c526 int null, c527 int null, c528 int null, c529 int null, c530 int null, c531 int null, c532 int null, c533 int null, c534 int null, c535 int null, c536 int null, c537 int null, c538 int null, c539 int null, c540 int null, c541 int null, c542 int null, c543 int null, c544 int null, c545 int null, c546 int null, c547 int null, c548 int null, c549 int null, c550 int null, c551 int null, c552 int null, c553 int null, c554 int null, c555 int null, c556 int null, c557 int null, c558 int null, c559 int null, c560 int null, c561 int null, c562 int null, c563 int null, c564 int null, c565 int null, c566 int null, c567 int null, c568 int null, c569 int null, c570 int null, c571 int null, c572 int null, c573 int null, c574 int null, c575 int null, c576 int null, c577 int null, c578 int null, c579 int null, c580 int null, c581 int null, c582 int null, c583 int null, c584 int null, c585 int null, c586 int null, c587 int null, c588 int null, c589 int null, c590 int null, c591 int null, c592 int null, c593 int null, c594 int null, c595 int null, c596 int null, c597 int null, c598 int null, c599 int null, c600 int null, c601 int null, c602 int null, c603 int null, c604 int null, c605 int null, c606 int null, c607 int null, c608 int null, c609 int null, c610 int null, c611 int null, c612 int null, c613 int null, c614 int null, c615 int null, c616 int null, c617 int null, c618 int null, c619 int null, c620 int null, c621 int null, c622 int null, c623 int null, c624 int null, c625 int null, c626 int null, c627 int null, c628 int null, c629 int null, c630 int null, c631 int null, c632 int null, c633 int null, c634 int null, c635 int null, c636 int null, c637 int null, c638 int null, c639 int null, c640 int null, c641 int null, c642 int null, c643 int null, c644 int null, c645 int null, c646 int null, c647 int null, c648 int null, c649 int null, c650 int null, c651 int null, c652 int null, c653 int null, c654 int null, c655 int null, c656 int null, c657 int null, c658 int null, c659 int null, c660 int null, c661 int null, c662 int null, c663 int null, c664 int null, c665 int null, c666 int null, c667 int null, c668 int null, c669 int null, c670 int null, c671 int null, c672 int null, c673 int null, c674 int null, c675 int null, c676 int null, c677 int null, c678 int null, c679 int null, c680 int null, c681 int null, c682 int null, c683 int null, c684 int null, c685 int null, c686 int null, c687 int null, c688 int null, c689 int null, c690 int null, c691 int null, c692 int null, c693 int null, c694 int null, c695 int null, c696 int null, c697 int null, c698 int null, c699 int null, c700 int null, c701 int null, c702 int null, c703 int null, c704 int null, c705 int null, c706 int null, c707 int null, c708 int null, c709 int null, c710 int null, c711 int null, c712 int null, c713 int null, c714 int null, c715 int null, c716 int null, c717 int null, c718 int null, c719 int null, c720 int null, c721 int null, c722 int null, c723 int null, c724 int null, c725 int null, c726 int null, c727 int null, c728 int null, c729 int null, c730 int null, c731 int null, c732 int null, c733 int null, c734 int null, c735 int null, c736 int null, c737 int null, c738 int null, c739 int null, c740 int null, c741 int null, c742 int null, c743 int null, c744 int null, c745 int null, c746 int null, c747 int null, c748 int null, c749 int null, c750 int null, c751 int null, c752 int null, c753 int null, c754 int null, c755 int null, c756 int null, c757 int null, c758 int null, c759 int null, c760 int null, c761 int null, c762 int null, c763 int null, c764 int null, c765 int null, c766 int null, c767 int null, c768 int null, c769 int null, c770 int null, c771 int null, c772 int null, c773 int null, c774 int null, c775 int null, c776 int null, c777 int null, c778 int null, c779 int null, c780 int null, c781 int null, c782 int null, c783 int null, c784 int null, c785 int null, c786 int null, c787 int null, c788 int null, c789 int null, c790 int null, c791 int null, c792 int null, c793 int null, c794 int null, c795 int null, c796 int null, c797 int null, c798 int null, c799 int null, c800 int null) insert into tmptest select /* 200 */ c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1, c1 from test tmp table size: 8683 MB avg time = 140058.5 ms median 80% of the times (ms) = {133942, 139532, 140559, 146201} =======END: PATCH=========