iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 91.276 | | σ | 221.767 | | min | 12.287 | | max | 640.120 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 13.732 | | σ | 3.162 | | min | 11.710 | | max | 21.319 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 15.031 | | σ | 0.832 | | min | 13.274 | | max | 15.799 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 14.121 | | σ | 1.034 | | min | 12.591 | | max | 15.244 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4164.750 | | σ | 1898.419 | | min | 1546.000 | | max | 7208.000 |
| | mean | 13.671 | | σ | 1.409 | | min | 11.329 | | max | 15.159 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.003 | | min | 27.603 | | max | 27.611 |
| | mean | 4164.750 | | σ | 1898.419 | | min | 1546.000 | | max | 7208.000 |
| | mean | 9.274 | | σ | 0.480 | | min | 8.629 | | max | 10.002 |
|
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 | 4164.750 | | σ | 1898.419 | | min | 1546.000 | | max | 7208.000 |
| | mean | 6.947 | | σ | 0.156 | | min | 6.779 | | max | 7.261 |
|
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 | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 6.299 | | σ | 0.495 | | min | 5.865 | | max | 7.462 |
|
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 | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 5.892 | | σ | 0.595 | | min | 5.480 | | max | 7.323 |
|
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 | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 6.021 | | σ | 0.664 | | min | 5.683 | | max | 7.647 |
|
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 | 4281.000 | | σ | 1975.187 | | min | 1546.000 | | max | 7208.000 |
| | mean | 5.862 | | σ | 0.594 | | min | 5.557 | | max | 7.318 |
|