iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 108.973 | | σ | 272.531 | | min | 12.351 | | max | 783.451 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 14.172 | | σ | 2.893 | | min | 12.733 | | max | 21.269 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 14.890 | | σ | 0.958 | | min | 13.136 | | max | 15.811 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 13.732 | | σ | 0.814 | | min | 12.544 | | max | 14.710 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4166.875 | | σ | 1897.838 | | min | 1552.000 | | max | 7208.000 |
| | mean | 13.147 | | σ | 1.130 | | min | 10.759 | | max | 14.158 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.003 | | min | 27.603 | | max | 27.611 |
| | mean | 4166.875 | | σ | 1897.838 | | min | 1552.000 | | max | 7208.000 |
| | mean | 9.131 | | σ | 0.276 | | min | 8.610 | | max | 9.401 |
|
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 | 4166.875 | | σ | 1897.838 | | min | 1552.000 | | max | 7208.000 |
| | mean | 7.103 | | σ | 0.105 | | min | 6.936 | | max | 7.274 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 6.202 | | σ | 0.571 | | min | 5.768 | | max | 7.575 |
|
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 | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 5.834 | | σ | 0.602 | | min | 5.485 | | max | 7.314 |
|
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 | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 5.856 | | σ | 0.585 | | min | 5.524 | | max | 7.293 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4283.375 | | σ | 1974.908 | | min | 1552.000 | | max | 7208.000 |
| | mean | 5.776 | | σ | 0.615 | | min | 5.458 | | max | 7.283 |
|