iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4280.500 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 12.780 | | σ | 0.359 | | min | 12.379 | | max | 13.412 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4280.500 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 13.562 | | σ | 2.176 | | min | 11.710 | | max | 18.649 |
|
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 | 15.089 | | σ | 0.775 | | min | 13.820 | | max | 15.827 |
|
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.706 | | σ | 0.856 | | min | 12.106 | | max | 14.469 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4163.250 | | σ | 1889.762 | | min | 1550.000 | | max | 7173.000 |
| | mean | 13.116 | | σ | 1.144 | | min | 10.935 | | max | 14.275 |
|
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 | 4163.250 | | σ | 1889.762 | | min | 1550.000 | | max | 7173.000 |
| | mean | 9.231 | | σ | 0.289 | | min | 8.779 | | max | 9.515 |
|
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 | 4163.250 | | σ | 1889.762 | | min | 1550.000 | | max | 7173.000 |
| | mean | 7.120 | | σ | 0.090 | | min | 6.940 | | max | 7.219 |
|
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 | 4280.500 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 6.203 | | σ | 0.543 | | min | 5.782 | | max | 7.516 |
|
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 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 5.815 | | σ | 0.537 | | min | 5.469 | | max | 7.127 |
|
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 | 4280.500 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 5.871 | | σ | 0.591 | | min | 5.591 | | max | 7.329 |
|
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 | 4280.500 | | σ | 1967.859 | | min | 1550.000 | | max | 7173.000 |
| | mean | 5.734 | | σ | 0.572 | | min | 5.413 | | max | 7.139 |
|