iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 98.897 | | σ | 244.148 | | min | 12.177 | | max | 703.133 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 13.320 | | σ | 0.911 | | min | 12.744 | | max | 15.504 |
|
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.962 | | σ | 0.680 | | min | 13.674 | | max | 15.724 |
|
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.056 | | σ | 0.895 | | min | 11.714 | | max | 14.169 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4172.250 | | σ | 1906.155 | | min | 1548.000 | | max | 7212.000 |
| | mean | 13.546 | | σ | 1.820 | | min | 10.718 | | max | 15.642 |
|
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 | 4172.250 | | σ | 1906.155 | | min | 1548.000 | | max | 7212.000 |
| | mean | 9.001 | | σ | 0.372 | | min | 8.256 | | max | 9.414 |
|
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 | 4172.250 | | σ | 1906.155 | | min | 1548.000 | | max | 7212.000 |
| | mean | 6.794 | | σ | 0.324 | | min | 6.404 | | max | 7.327 |
|
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 | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.996 | | σ | 0.142 | | min | 5.810 | | max | 6.236 |
|
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 | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.566 | | σ | 0.116 | | min | 5.307 | | max | 5.685 |
|
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 | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.682 | | σ | 0.119 | | min | 5.440 | | max | 5.828 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4289.125 | | σ | 1984.150 | | min | 1548.000 | | max | 7212.000 |
| | mean | 5.497 | | σ | 0.169 | | min | 5.141 | | max | 5.740 |
|