iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.604 | | σ | 0.002 | | min | 36.603 | | max | 36.607 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 71.392 | | σ | 166.180 | | min | 12.460 | | max | 482.665 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.604 | | σ | 0.002 | | min | 36.603 | | max | 36.607 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 13.134 | | σ | 1.233 | | min | 12.045 | | max | 16.014 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.922 | | σ | 0.002 | | min | 41.920 | | max | 41.924 |
| | mean | 7207.000 | | σ | 0.000 | | min | 7207.000 | | max | 7207.000 |
| | mean | 14.806 | | σ | 0.891 | | min | 12.769 | | max | 15.466 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.921 | | σ | 0.002 | | min | 41.919 | | max | 41.924 |
| | mean | 7207.000 | | σ | 0.000 | | min | 7207.000 | | max | 7207.000 |
| | mean | 13.438 | | σ | 0.990 | | min | 12.005 | | max | 14.300 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.920 | | σ | 0.002 | | min | 41.919 | | max | 41.923 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 13.331 | | σ | 1.647 | | min | 10.782 | | max | 15.452 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.582 | | σ | 0.002 | | min | 27.581 | | max | 27.585 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 8.918 | | σ | 0.303 | | min | 8.444 | | max | 9.273 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.378 | | σ | 0.002 | | min | 26.377 | | max | 26.381 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 6.966 | | σ | 0.172 | | min | 6.628 | | max | 7.173 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.647 | | σ | 0.002 | | min | 25.646 | | max | 25.650 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 6.019 | | σ | 0.174 | | min | 5.782 | | max | 6.310 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.642 | | σ | 0.002 | | min | 25.640 | | max | 25.644 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.610 | | σ | 0.046 | | min | 5.535 | | max | 5.655 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.945 | | σ | 0.002 | | min | 25.944 | | max | 25.949 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.650 | | σ | 0.057 | | min | 5.563 | | max | 5.724 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.945 | | σ | 0.002 | | min | 25.944 | | max | 25.948 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.654 | | σ | 0.260 | | min | 5.513 | | max | 6.291 |
|