iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 101.379 | | σ | 250.861 | | min | 12.443 | | max | 722.229 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 13.984 | | σ | 2.747 | | min | 12.188 | | max | 20.721 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7209.000 | | σ | 0.000 | | min | 7209.000 | | max | 7209.000 |
| | mean | 14.816 | | σ | 0.949 | | min | 12.893 | | max | 15.594 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7209.000 | | σ | 0.000 | | min | 7209.000 | | max | 7209.000 |
| | mean | 13.565 | | σ | 0.913 | | min | 12.119 | | max | 14.415 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4168.625 | | σ | 1902.642 | | min | 1550.000 | | max | 7209.000 |
| | mean | 13.955 | | σ | 1.419 | | min | 11.274 | | max | 15.545 |
|
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 | 4168.625 | | σ | 1902.642 | | min | 1550.000 | | max | 7209.000 |
| | mean | 9.252 | | σ | 0.498 | | min | 8.777 | | max | 10.246 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4168.625 | | σ | 1902.642 | | min | 1550.000 | | max | 7209.000 |
| | mean | 6.646 | | σ | 0.136 | | min | 6.462 | | max | 6.871 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 6.347 | | σ | 0.969 | | min | 5.795 | | max | 8.730 |
|
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 | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 5.798 | | σ | 0.448 | | min | 5.548 | | max | 6.888 |
|
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 | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 5.941 | | σ | 0.487 | | min | 5.649 | | max | 7.122 |
|
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 | 4285.125 | | σ | 1980.080 | | min | 1550.000 | | max | 7209.000 |
| | mean | 5.805 | | σ | 0.367 | | min | 5.542 | | max | 6.656 |
|