iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 92.344 | | σ | 225.079 | | min | 12.334 | | max | 649.386 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 13.833 | | σ | 3.056 | | min | 11.798 | | max | 21.231 |
|
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.947 | | σ | 0.767 | | min | 13.537 | | max | 15.803 |
|
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.957 | | σ | 1.186 | | min | 12.173 | | max | 15.582 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4169.750 | | σ | 1898.013 | | min | 1551.000 | | max | 7212.000 |
| | mean | 13.750 | | σ | 1.492 | | min | 11.184 | | max | 15.411 |
|
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.750 | | σ | 1898.013 | | min | 1551.000 | | max | 7212.000 |
| | mean | 9.310 | | σ | 0.453 | | min | 8.569 | | max | 9.925 |
|
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.750 | | σ | 1898.013 | | min | 1551.000 | | max | 7212.000 |
| | mean | 6.710 | | σ | 0.498 | | min | 5.939 | | max | 7.504 |
|
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.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 6.285 | | σ | 0.629 | | min | 5.713 | | max | 7.791 |
|
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.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.699 | | σ | 0.484 | | min | 5.231 | | max | 6.847 |
|
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.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.781 | | σ | 0.525 | | min | 5.352 | | max | 7.017 |
|
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.250 | | σ | 1974.950 | | min | 1551.000 | | max | 7212.000 |
| | mean | 5.688 | | σ | 0.571 | | min | 4.926 | | max | 6.904 |
|