iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4171.875 | | σ | 1899.226 | | min | 1552.000 | | max | 7205.000 |
| | mean | 12.318 | | σ | 0.418 | | min | 11.863 | | max | 13.010 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4291.875 | | σ | 1978.942 | | min | 1552.000 | | max | 7205.000 |
| | mean | 103.269 | | σ | 255.890 | | min | 12.575 | | max | 736.563 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7205.000 | | σ | 0.000 | | min | 7205.000 | | max | 7205.000 |
| | mean | 14.246 | | σ | 1.215 | | min | 11.716 | | max | 15.070 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7205.000 | | σ | 0.000 | | min | 7205.000 | | max | 7205.000 |
| | mean | 12.890 | | σ | 1.110 | | min | 10.806 | | max | 14.162 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4171.875 | | σ | 1899.226 | | min | 1552.000 | | max | 7205.000 |
| | mean | 12.721 | | σ | 1.458 | | min | 10.784 | | max | 14.688 |
|
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 | 4171.875 | | σ | 1899.226 | | min | 1552.000 | | max | 7205.000 |
| | mean | 8.542 | | σ | 0.254 | | min | 8.131 | | max | 8.847 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.401 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4171.875 | | σ | 1899.226 | | min | 1552.000 | | max | 7205.000 |
| | mean | 6.603 | | σ | 0.299 | | min | 6.097 | | max | 6.924 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4291.875 | | σ | 1978.942 | | min | 1552.000 | | max | 7205.000 |
| | mean | 5.721 | | σ | 0.593 | | min | 5.386 | | max | 7.154 |
|
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 | 4291.875 | | σ | 1978.942 | | min | 1552.000 | | max | 7205.000 |
| | mean | 5.415 | | σ | 0.541 | | min | 5.071 | | max | 6.731 |
|
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 | 4291.875 | | σ | 1978.942 | | min | 1552.000 | | max | 7205.000 |
| | mean | 5.373 | | σ | 0.403 | | min | 5.135 | | max | 6.357 |
|
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 | 4291.875 | | σ | 1978.942 | | min | 1552.000 | | max | 7205.000 |
| | mean | 5.260 | | σ | 0.392 | | min | 5.053 | | max | 6.208 |
|