iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4167.000 | | σ | 1898.082 | | min | 1549.000 | | max | 7199.000 |
| | mean | 12.630 | | σ | 0.436 | | min | 12.290 | | max | 13.652 |
|
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 | | σ | 1977.767 | | min | 1549.000 | | max | 7199.000 |
| | mean | 66.393 | | σ | 152.069 | | min | 11.579 | | max | 442.743 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7199.000 | | σ | 0.000 | | min | 7199.000 | | max | 7199.000 |
| | mean | 15.069 | | σ | 1.471 | | min | 11.857 | | max | 15.951 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7199.000 | | σ | 0.000 | | min | 7199.000 | | max | 7199.000 |
| | mean | 13.712 | | σ | 1.341 | | min | 11.777 | | max | 15.820 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4167.000 | | σ | 1898.082 | | min | 1549.000 | | max | 7199.000 |
| | mean | 13.625 | | σ | 1.486 | | min | 11.281 | | max | 15.359 |
|
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 | 4167.000 | | σ | 1898.082 | | min | 1549.000 | | max | 7199.000 |
| | mean | 9.333 | | σ | 0.444 | | min | 8.672 | | max | 9.840 |
|
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 | 4167.000 | | σ | 1898.082 | | min | 1549.000 | | max | 7199.000 |
| | mean | 6.673 | | σ | 0.447 | | min | 5.900 | | max | 7.155 |
|
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 | | σ | 1977.767 | | min | 1549.000 | | max | 7199.000 |
| | mean | 6.123 | | σ | 0.131 | | min | 5.970 | | max | 6.310 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661 | | σ | 0.003 | | min | 25.659 | | max | 25.667 |
| | mean | 4287.000 | | σ | 1977.767 | | min | 1549.000 | | max | 7199.000 |
| | mean | 5.503 | | σ | 0.169 | | min | 5.149 | | max | 5.653 |
|
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 | | σ | 1977.767 | | min | 1549.000 | | max | 7199.000 |
| | mean | 5.588 | | σ | 0.214 | | min | 5.230 | | max | 5.861 |
|
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 | 4287.000 | | σ | 1977.767 | | min | 1549.000 | | max | 7199.000 |
| | mean | 5.518 | | σ | 0.166 | | min | 5.280 | | max | 5.828 |
|