iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 95.047 | | σ | 232.649 | | min | 12.597 | | max | 670.825 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 14.610 | | σ | 4.277 | | min | 12.610 | | max | 25.180 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7210.000 | | σ | 0.000 | | min | 7210.000 | | max | 7210.000 |
| | mean | 15.000 | | σ | 1.090 | | min | 12.728 | | max | 15.962 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7210.000 | | σ | 0.000 | | min | 7210.000 | | max | 7210.000 |
| | mean | 13.540 | | σ | 1.432 | | min | 11.124 | | max | 14.776 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4169.250 | | σ | 1904.322 | | min | 1549.000 | | max | 7210.000 |
| | mean | 13.646 | | σ | 1.557 | | min | 11.273 | | max | 15.374 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4169.250 | | σ | 1904.322 | | min | 1549.000 | | max | 7210.000 |
| | mean | 8.965 | | σ | 0.431 | | min | 8.057 | | max | 9.399 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4169.250 | | σ | 1904.322 | | min | 1549.000 | | max | 7210.000 |
| | mean | 6.927 | | σ | 0.256 | | min | 6.396 | | max | 7.270 |
|
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 | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 6.402 | | σ | 0.996 | | min | 5.855 | | max | 8.843 |
|
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 | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 5.998 | | σ | 1.045 | | min | 5.487 | | max | 8.564 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.003 | | min | 25.967 | | max | 25.975 |
| | mean | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 6.022 | | σ | 1.033 | | min | 5.582 | | max | 8.572 |
|
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 | 4285.625 | | σ | 1981.810 | | min | 1549.000 | | max | 7210.000 |
| | mean | 5.996 | | σ | 0.935 | | min | 5.495 | | max | 8.263 |
|