iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 104.475 | | σ | 259.509 | | min | 12.452 | | max | 746.727 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 13.937 | | σ | 2.551 | | min | 12.447 | | max | 20.194 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 14.931 | | σ | 0.858 | | min | 13.463 | | max | 15.711 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 13.955 | | σ | 0.864 | | min | 12.338 | | max | 15.088 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4175.875 | | σ | 1903.211 | | min | 1555.000 | | max | 7214.000 |
| | mean | 13.702 | | σ | 1.723 | | min | 11.156 | | max | 15.417 |
|
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 | 4175.875 | | σ | 1903.211 | | min | 1555.000 | | max | 7214.000 |
| | mean | 9.219 | | σ | 0.360 | | min | 8.702 | | max | 9.859 |
|
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 | 4175.875 | | σ | 1903.211 | | min | 1555.000 | | max | 7214.000 |
| | mean | 6.691 | | σ | 0.494 | | min | 5.950 | | max | 7.429 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 6.336 | | σ | 0.470 | | min | 5.821 | | max | 7.354 |
|
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 | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 5.742 | | σ | 0.586 | | min | 5.244 | | max | 7.118 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 5.798 | | σ | 0.624 | | min | 5.197 | | max | 7.239 |
|
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 | 4292.125 | | σ | 1980.590 | | min | 1555.000 | | max | 7214.000 |
| | mean | 5.704 | | σ | 0.643 | | min | 5.199 | | max | 7.220 |
|