iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 91.570 | | σ | 222.426 | | min | 12.479 | | max | 642.046 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 13.628 | | σ | 2.960 | | min | 11.957 | | max | 20.847 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 14.933 | | σ | 0.950 | | min | 13.230 | | max | 15.713 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 13.478 | | σ | 0.757 | | min | 12.479 | | max | 14.461 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4169.625 | | σ | 1903.191 | | min | 1550.000 | | max | 7211.000 |
| | mean | 13.636 | | σ | 1.825 | | min | 10.851 | | max | 15.499 |
|
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.625 | | σ | 1903.191 | | min | 1550.000 | | max | 7211.000 |
| | mean | 9.063 | | σ | 0.420 | | min | 8.438 | | max | 9.620 |
|
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.625 | | σ | 1903.191 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.794 | | σ | 0.278 | | min | 6.355 | | max | 7.151 |
|
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 | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.123 | | σ | 0.685 | | min | 5.782 | | max | 7.805 |
|
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 | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.835 | | σ | 0.705 | | min | 5.128 | | max | 7.260 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.805 | | σ | 0.683 | | min | 5.125 | | max | 7.355 |
|
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 | 4285.625 | | σ | 1980.299 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.636 | | σ | 0.719 | | min | 4.986 | | max | 7.286 |
|