iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 117.996 | | σ | 297.203 | | min | 12.569 | | max | 853.535 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 13.926 | | σ | 3.319 | | min | 11.891 | | max | 21.980 |
|
iterations=8 operation_display=table_records(), no indexes 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 | 14.897 | | σ | 0.874 | | min | 13.226 | | max | 15.640 |
|
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.522 | | σ | 0.964 | | min | 11.868 | | max | 14.462 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.125 | | σ | 1903.025 | | min | 1550.000 | | max | 7211.000 |
| | mean | 13.933 | | σ | 1.610 | | min | 11.169 | | max | 15.442 |
|
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 | 4170.125 | | σ | 1903.025 | | min | 1550.000 | | max | 7211.000 |
| | mean | 8.895 | | σ | 0.360 | | min | 8.167 | | max | 9.200 |
|
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 | 4170.125 | | σ | 1903.025 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.953 | | σ | 0.154 | | min | 6.673 | | max | 7.141 |
|
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 | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 6.164 | | σ | 0.583 | | min | 5.823 | | max | 7.576 |
|
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 | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.883 | | σ | 0.590 | | min | 5.602 | | max | 7.337 |
|
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 | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.971 | | σ | 0.739 | | min | 5.635 | | max | 7.796 |
|
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 | 4287.000 | | σ | 1980.679 | | min | 1550.000 | | max | 7211.000 |
| | mean | 5.804 | | σ | 0.603 | | min | 5.516 | | max | 7.284 |
|