iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 85.382 | | σ | 206.050 | | min | 12.311 | | max | 595.329 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 13.748 | | σ | 3.003 | | min | 12.097 | | max | 21.029 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 14.946 | | σ | 0.813 | | min | 13.123 | | max | 15.540 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 14.252 | | σ | 1.426 | | min | 11.171 | | max | 15.542 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4173.625 | | σ | 1904.153 | | min | 1553.000 | | max | 7213.000 |
| | mean | 13.817 | | σ | 1.569 | | min | 11.278 | | max | 15.450 |
|
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 | 4173.625 | | σ | 1904.153 | | min | 1553.000 | | max | 7213.000 |
| | mean | 9.378 | | σ | 0.389 | | min | 8.884 | | max | 9.731 |
|
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 | 4173.625 | | σ | 1904.153 | | min | 1553.000 | | max | 7213.000 |
| | mean | 6.481 | | σ | 0.477 | | min | 5.691 | | max | 7.135 |
|
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 | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 6.206 | | σ | 0.699 | | min | 5.643 | | max | 7.863 |
|
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 | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 5.751 | | σ | 0.804 | | min | 5.267 | | max | 7.684 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 5.685 | | σ | 0.497 | | min | 5.278 | | max | 6.867 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.001 | | min | 25.967 | | max | 25.971 |
| | mean | 4289.875 | | σ | 1981.646 | | min | 1553.000 | | max | 7213.000 |
| | mean | 5.581 | | σ | 0.486 | | min | 5.201 | | max | 6.759 |
|