iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 12.657 | | σ | 0.383 | | min | 12.163 | | max | 13.247 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 12.972 | | σ | 0.663 | | min | 11.832 | | max | 13.990 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7173.000 | | σ | 0.000 | | min | 7173.000 | | max | 7173.000 |
| | mean | 14.955 | | σ | 0.675 | | min | 13.785 | | max | 15.784 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7173.000 | | σ | 0.000 | | min | 7173.000 | | max | 7173.000 |
| | mean | 13.441 | | σ | 1.256 | | min | 11.371 | | max | 14.510 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4166.125 | | σ | 1888.756 | | min | 1554.000 | | max | 7173.000 |
| | mean | 13.636 | | σ | 1.853 | | min | 11.032 | | max | 15.554 |
|
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 | 4166.125 | | σ | 1888.756 | | min | 1554.000 | | max | 7173.000 |
| | mean | 9.037 | | σ | 0.136 | | min | 8.864 | | max | 9.251 |
|
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 | 4166.125 | | σ | 1888.756 | | min | 1554.000 | | max | 7173.000 |
| | mean | 6.934 | | σ | 0.484 | | min | 5.763 | | max | 7.236 |
|
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 | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 6.028 | | σ | 0.110 | | min | 5.888 | | max | 6.181 |
|
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 | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 5.658 | | σ | 0.141 | | min | 5.453 | | max | 5.963 |
|
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 | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 5.672 | | σ | 0.084 | | min | 5.502 | | max | 5.767 |
|
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 | 4283.125 | | σ | 1966.745 | | min | 1554.000 | | max | 7173.000 |
| | mean | 5.554 | | σ | 0.095 | | min | 5.440 | | max | 5.707 |
|