iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4286.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 85.986 | | σ | 209.412 | | min | 11.790 | | max | 604.254 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 13.101 | | σ | 2.899 | | min | 11.293 | | max | 20.164 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 14.289 | | σ | 0.922 | | min | 12.326 | | max | 14.995 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 13.121 | | σ | 1.089 | | min | 11.180 | | max | 13.943 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.750 | | σ | 1903.567 | | min | 1551.000 | | max | 7212.000 |
| | mean | 12.689 | | σ | 1.775 | | min | 10.243 | | max | 14.870 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4170.750 | | σ | 1903.567 | | min | 1551.000 | | max | 7212.000 |
| | mean | 8.583 | | σ | 0.399 | | min | 8.035 | | max | 9.081 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4170.750 | | σ | 1903.567 | | min | 1551.000 | | max | 7212.000 |
| | mean | 6.542 | | σ | 0.201 | | min | 6.191 | | max | 6.837 |
|
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 | 4286.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.830 | | σ | 0.555 | | min | 5.456 | | max | 7.178 |
|
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.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.360 | | σ | 0.606 | | min | 5.098 | | max | 6.858 |
|
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 | 4286.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.485 | | σ | 0.600 | | min | 5.158 | | max | 6.963 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4286.875 | | σ | 1980.829 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.345 | | σ | 0.597 | | min | 5.017 | | max | 6.813 |
|