iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4286.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 97.066 | | σ | 238.037 | | min | 12.669 | | max | 686.177 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4286.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 14.026 | | σ | 2.923 | | min | 11.909 | | max | 21.150 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7209.000 | | σ | 0.000 | | min | 7209.000 | | max | 7209.000 |
| | mean | 14.999 | | σ | 0.910 | | min | 13.287 | | max | 16.193 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7209.000 | | σ | 0.000 | | min | 7209.000 | | max | 7209.000 |
| | mean | 13.771 | | σ | 1.081 | | min | 11.796 | | max | 14.522 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.250 | | σ | 1904.038 | | min | 1552.000 | | max | 7209.000 |
| | mean | 13.694 | | σ | 1.679 | | min | 11.260 | | max | 15.301 |
|
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.250 | | σ | 1904.038 | | min | 1552.000 | | max | 7209.000 |
| | mean | 9.069 | | σ | 0.280 | | min | 8.647 | | max | 9.482 |
|
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.250 | | σ | 1904.038 | | min | 1552.000 | | max | 7209.000 |
| | mean | 6.871 | | σ | 0.241 | | min | 6.440 | | max | 7.270 |
|
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.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 6.331 | | σ | 0.676 | | min | 5.945 | | max | 7.985 |
|
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.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 5.874 | | σ | 0.626 | | min | 5.316 | | max | 7.356 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.003 | | min | 25.967 | | max | 25.975 |
| | mean | 4286.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 5.938 | | σ | 0.608 | | min | 5.350 | | max | 7.374 |
|
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 | 4286.625 | | σ | 1981.604 | | min | 1552.000 | | max | 7209.000 |
| | mean | 5.768 | | σ | 0.651 | | min | 5.032 | | max | 7.282 |
|