iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 12.834 | | σ | 0.234 | | min | 12.565 | | max | 13.177 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.619 |
| | mean | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 12.921 | | σ | 2.263 | | min | 11.909 | | max | 18.513 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7172.000 | | σ | 0.000 | | min | 7172.000 | | max | 7172.000 |
| | mean | 15.060 | | σ | 0.657 | | min | 13.951 | | max | 15.684 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7172.000 | | σ | 0.000 | | min | 7172.000 | | max | 7172.000 |
| | mean | 13.892 | | σ | 0.795 | | min | 12.675 | | max | 15.047 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4163.750 | | σ | 1892.567 | | min | 1553.000 | | max | 7172.000 |
| | mean | 13.797 | | σ | 1.655 | | min | 11.272 | | max | 15.238 |
|
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 | 4163.750 | | σ | 1892.567 | | min | 1553.000 | | max | 7172.000 |
| | mean | 9.092 | | σ | 0.485 | | min | 8.471 | | max | 9.625 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.401 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4163.750 | | σ | 1892.567 | | min | 1553.000 | | max | 7172.000 |
| | mean | 6.976 | | σ | 0.472 | | min | 6.146 | | max | 7.410 |
|
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 | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 6.205 | | σ | 0.583 | | min | 5.817 | | max | 7.581 |
|
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 | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 6.016 | | σ | 0.677 | | min | 5.645 | | max | 7.622 |
|
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 | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 5.926 | | σ | 0.428 | | min | 5.750 | | max | 6.984 |
|
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 | 4280.500 | | σ | 1970.683 | | min | 1553.000 | | max | 7172.000 |
| | mean | 5.896 | | σ | 0.640 | | min | 5.585 | | max | 7.469 |
|