iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 112.878 | | σ | 283.092 | | min | 12.351 | | max | 813.495 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 13.997 | | σ | 3.023 | | min | 12.255 | | max | 21.405 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 15.148 | | σ | 0.888 | | min | 13.675 | | max | 15.890 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7212.000 | | σ | 0.000 | | min | 7212.000 | | max | 7212.000 |
| | mean | 13.979 | | σ | 0.776 | | min | 12.690 | | max | 14.660 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4167.375 | | σ | 1899.888 | | min | 1547.000 | | max | 7212.000 |
| | mean | 13.369 | | σ | 1.250 | | min | 11.321 | | max | 15.167 |
|
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 | 4167.375 | | σ | 1899.888 | | min | 1547.000 | | max | 7212.000 |
| | mean | 8.881 | | σ | 0.415 | | min | 8.351 | | max | 9.340 |
|
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 | 4167.375 | | σ | 1899.888 | | min | 1547.000 | | max | 7212.000 |
| | mean | 6.947 | | σ | 0.222 | | min | 6.641 | | max | 7.262 |
|
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 | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 6.222 | | σ | 0.607 | | min | 5.803 | | max | 7.700 |
|
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 | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 5.818 | | σ | 0.508 | | min | 5.516 | | max | 7.042 |
|
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 | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 5.917 | | σ | 0.591 | | min | 5.621 | | max | 7.373 |
|
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 | 4284.000 | | σ | 1977.022 | | min | 1547.000 | | max | 7212.000 |
| | mean | 5.883 | | σ | 0.562 | | min | 5.530 | | max | 7.193 |
|