iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4164.125 | | σ | 1896.855 | | min | 1549.000 | | max | 7196.000 |
| | mean | 12.644 | | σ | 0.279 | | min | 12.359 | | max | 13.214 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4283.750 | | σ | 1976.245 | | min | 1549.000 | | max | 7196.000 |
| | mean | 103.835 | | σ | 256.345 | | min | 12.974 | | max | 738.257 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7196.000 | | σ | 0.000 | | min | 7196.000 | | max | 7196.000 |
| | mean | 14.850 | | σ | 1.420 | | min | 11.618 | | max | 15.705 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7196.000 | | σ | 0.000 | | min | 7196.000 | | max | 7196.000 |
| | mean | 13.887 | | σ | 1.347 | | min | 11.535 | | max | 15.424 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4164.125 | | σ | 1896.855 | | min | 1549.000 | | max | 7196.000 |
| | mean | 13.500 | | σ | 1.765 | | min | 10.906 | | max | 15.259 |
|
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 | 4164.125 | | σ | 1896.855 | | min | 1549.000 | | max | 7196.000 |
| | mean | 8.879 | | σ | 0.254 | | min | 8.499 | | max | 9.246 |
|
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 | 4164.125 | | σ | 1896.855 | | min | 1549.000 | | max | 7196.000 |
| | mean | 6.996 | | σ | 0.309 | | min | 6.756 | | max | 7.727 |
|
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 | 4283.750 | | σ | 1976.245 | | min | 1549.000 | | max | 7196.000 |
| | mean | 6.239 | | σ | 0.600 | | min | 5.866 | | max | 7.703 |
|
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 | 4283.750 | | σ | 1976.245 | | min | 1549.000 | | max | 7196.000 |
| | mean | 5.838 | | σ | 0.610 | | min | 5.517 | | max | 7.336 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4283.750 | | σ | 1976.245 | | min | 1549.000 | | max | 7196.000 |
| | mean | 5.922 | | σ | 0.637 | | min | 5.608 | | max | 7.488 |
|
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 | 4283.750 | | σ | 1976.245 | | min | 1549.000 | | max | 7196.000 |
| | mean | 5.775 | | σ | 0.624 | | min | 5.458 | | max | 7.315 |
|