iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 109.235 | | σ | 273.420 | | min | 12.249 | | max | 785.915 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 13.633 | | σ | 4.451 | | min | 11.703 | | max | 24.620 |
|
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 | 14.832 | | σ | 0.817 | | min | 13.514 | | max | 15.858 |
|
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 | 12.514 | | σ | 1.257 | | min | 10.987 | | max | 14.532 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4175.375 | | σ | 1906.698 | | min | 1550.000 | | max | 7216.000 |
| | mean | 13.563 | | σ | 1.598 | | min | 11.018 | | max | 15.348 |
|
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 | 4175.375 | | σ | 1906.698 | | min | 1550.000 | | max | 7216.000 |
| | mean | 9.100 | | σ | 0.341 | | min | 8.535 | | max | 9.675 |
|
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 | 4175.375 | | σ | 1906.698 | | min | 1550.000 | | max | 7216.000 |
| | mean | 6.995 | | σ | 0.271 | | min | 6.497 | | max | 7.263 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 6.256 | | σ | 1.190 | | min | 5.640 | | max | 9.184 |
|
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 | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 5.924 | | σ | 0.900 | | min | 5.474 | | max | 8.141 |
|
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 | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 6.027 | | σ | 1.050 | | min | 5.551 | | max | 8.612 |
|
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 | 4292.000 | | σ | 1984.509 | | min | 1550.000 | | max | 7216.000 |
| | mean | 5.916 | | σ | 1.038 | | min | 5.488 | | max | 8.481 |
|