op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 12.284 | | σ | 0.269 | | min | 11.932 | | max | 12.655 |
|
op=column_set() on indexed, repeat | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 12.395 | | σ | 0.668 | | min | 11.239 | | max | 12.863 |
|
op=table_records(), no indexes | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7150.000 | | σ | 0.000 | | min | 7150.000 | | max | 7150.000 |
| | mean | 14.712 | | σ | 0.191 | | min | 14.418 | | max | 15.019 |
|
op=table_records(), repeat | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 13.614 | | σ | 1.559 | | min | 10.259 | | max | 15.279 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 9.309 | | σ | 1.357 | | min | 8.292 | | max | 12.373 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 7.234 | | σ | 1.224 | | min | 6.218 | | max | 9.914 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.004 | | min | 25.666 | | max | 25.678 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 5.589 | | σ | 0.093 | | min | 5.388 | | max | 5.682 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.969 | | max | 25.972 |
| | mean | 4042.500 | | σ | 2009.182 | | min | 1218.000 | | max | 7150.000 |
| | mean | 5.399 | | σ | 0.071 | | min | 5.290 | | max | 5.493 |
|