iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 110.058 | | σ | 275.426 | | min | 12.516 | | max | 791.702 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 13.958 | | σ | 2.788 | | min | 12.092 | | max | 20.793 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 15.005 | | σ | 0.883 | | min | 13.016 | | max | 15.715 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 13.579 | | σ | 0.896 | | min | 11.872 | | max | 14.684 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4172.875 | | σ | 1904.076 | | min | 1554.000 | | max | 7211.000 |
| | mean | 13.978 | | σ | 1.674 | | min | 11.195 | | max | 15.415 |
|
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 | 4172.875 | | σ | 1904.076 | | min | 1554.000 | | max | 7211.000 |
| | mean | 9.108 | | σ | 0.383 | | min | 8.561 | | max | 9.669 |
|
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 | 4172.875 | | σ | 1904.076 | | min | 1554.000 | | max | 7211.000 |
| | mean | 6.876 | | σ | 0.185 | | min | 6.510 | | max | 7.107 |
|
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 | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 6.206 | | σ | 0.531 | | min | 5.835 | | max | 7.501 |
|
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 | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 5.877 | | σ | 0.606 | | min | 5.565 | | max | 7.359 |
|
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 | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 5.930 | | σ | 0.575 | | min | 5.615 | | max | 7.301 |
|
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 | 4289.750 | | σ | 1981.976 | | min | 1554.000 | | max | 7211.000 |
| | mean | 5.920 | | σ | 0.615 | | min | 5.531 | | max | 7.265 |
|