iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 111.760 | | σ | 279.006 | | min | 12.756 | | max | 802.265 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 13.854 | | σ | 3.028 | | min | 12.113 | | max | 21.254 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7216.000 | | σ | 0.000 | | min | 7216.000 | | max | 7216.000 |
| | mean | 15.062 | | σ | 0.939 | | min | 13.085 | | max | 15.783 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7216.000 | | σ | 0.000 | | min | 7216.000 | | max | 7216.000 |
| | mean | 13.449 | | σ | 0.805 | | min | 12.269 | | max | 14.481 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.625 | | σ | 1899.434 | | min | 1552.000 | | max | 7216.000 |
| | mean | 13.139 | | σ | 1.239 | | min | 11.520 | | max | 14.634 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.604 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4170.625 | | σ | 1899.434 | | min | 1552.000 | | max | 7216.000 |
| | mean | 9.132 | | σ | 0.373 | | min | 8.490 | | max | 9.533 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4170.625 | | σ | 1899.434 | | min | 1552.000 | | max | 7216.000 |
| | mean | 6.998 | | σ | 0.527 | | min | 6.067 | | max | 7.424 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.668 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 6.171 | | σ | 0.536 | | min | 5.772 | | max | 7.453 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 5.950 | | σ | 0.551 | | min | 5.606 | | max | 7.270 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 6.063 | | σ | 0.594 | | min | 5.494 | | max | 7.354 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4287.750 | | σ | 1976.741 | | min | 1552.000 | | max | 7216.000 |
| | mean | 5.741 | | σ | 0.587 | | min | 5.209 | | max | 7.141 |
|