iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 104.592 | | σ | 259.419 | | min | 12.517 | | max | 746.621 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 13.890 | | σ | 3.030 | | min | 11.900 | | max | 21.208 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 15.067 | | σ | 0.666 | | min | 14.034 | | max | 15.844 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 13.488 | | σ | 1.200 | | min | 11.741 | | max | 14.429 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4169.375 | | σ | 1903.574 | | min | 1551.000 | | max | 7214.000 |
| | mean | 13.623 | | σ | 1.769 | | min | 11.030 | | max | 15.233 |
|
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 | 4169.375 | | σ | 1903.574 | | min | 1551.000 | | max | 7214.000 |
| | mean | 8.829 | | σ | 0.318 | | min | 8.294 | | max | 9.190 |
|
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 | 4169.375 | | σ | 1903.574 | | min | 1551.000 | | max | 7214.000 |
| | mean | 6.927 | | σ | 0.192 | | min | 6.549 | | max | 7.171 |
|
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 | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 6.295 | | σ | 0.846 | | min | 5.731 | | max | 8.354 |
|
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 | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 5.808 | | σ | 0.645 | | min | 5.462 | | max | 7.398 |
|
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 | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 5.916 | | σ | 0.625 | | min | 5.631 | | max | 7.453 |
|
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 | 4286.125 | | σ | 1981.080 | | min | 1551.000 | | max | 7214.000 |
| | mean | 5.823 | | σ | 0.582 | | min | 5.497 | | max | 7.240 |
|