iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.619 |
| | mean | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 76.096 | | σ | 178.763 | | min | 12.491 | | max | 518.510 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 13.073 | | σ | 0.652 | | min | 12.025 | | max | 13.802 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 15.090 | | σ | 0.764 | | min | 13.499 | | max | 15.627 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7213.000 | | σ | 0.000 | | min | 7213.000 | | max | 7213.000 |
| | mean | 14.268 | | σ | 1.479 | | min | 11.522 | | max | 15.612 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4171.625 | | σ | 1898.209 | | min | 1554.000 | | max | 7213.000 |
| | mean | 13.881 | | σ | 1.728 | | min | 11.252 | | max | 15.628 |
|
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 | 4171.625 | | σ | 1898.209 | | min | 1554.000 | | max | 7213.000 |
| | mean | 9.338 | | σ | 0.339 | | min | 8.656 | | max | 9.682 |
|
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 | 4171.625 | | σ | 1898.209 | | min | 1554.000 | | max | 7213.000 |
| | mean | 6.883 | | σ | 0.275 | | min | 6.452 | | max | 7.248 |
|
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 | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 6.161 | | σ | 0.097 | | min | 6.027 | | max | 6.284 |
|
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 | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 5.725 | | σ | 0.081 | | min | 5.581 | | max | 5.820 |
|
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 | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 5.802 | | σ | 0.061 | | min | 5.711 | | max | 5.886 |
|
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 | 4288.625 | | σ | 1975.521 | | min | 1554.000 | | max | 7213.000 |
| | mean | 5.678 | | σ | 0.073 | | min | 5.568 | | max | 5.760 |
|