op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 12.989 | | σ | 1.763 | | min | 11.993 | | max | 17.284 |
|
op=column_set() on indexed, repeat | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 13.003 | | σ | 1.637 | | min | 11.407 | | max | 16.805 |
|
op=table_records(), no indexes | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7149.000 | | σ | 0.000 | | min | 7149.000 | | max | 7149.000 |
| | mean | 14.768 | | σ | 0.203 | | min | 14.482 | | max | 15.032 |
|
op=table_records(), repeat | | mean | 41.930 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 14.280 | | σ | 1.670 | | min | 10.372 | | max | 15.390 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 9.113 | | σ | 1.234 | | min | 8.033 | | max | 11.877 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 7.047 | | σ | 1.252 | | min | 6.144 | | max | 9.732 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.004 | | min | 25.665 | | max | 25.677 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 5.592 | | σ | 0.530 | | min | 5.297 | | max | 6.859 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.968 | | max | 25.972 |
| | mean | 4044.500 | | σ | 2010.123 | | min | 1218.000 | | max | 7149.000 |
| | mean | 5.503 | | σ | 0.514 | | min | 5.177 | | max | 6.757 |
|