op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 12.474 | | σ | 0.294 | | min | 12.065 | | max | 12.902 |
|
op=column_set() on indexed, repeat | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 12.421 | | σ | 0.784 | | min | 11.246 | | max | 13.274 |
|
op=table_records(), no indexes | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7158.000 | | σ | 0.000 | | min | 7158.000 | | max | 7158.000 |
| | mean | 14.639 | | σ | 0.071 | | min | 14.513 | | max | 14.723 |
|
op=table_records(), repeat | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 13.383 | | σ | 1.679 | | min | 10.739 | | max | 14.888 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 8.899 | | σ | 1.195 | | min | 8.199 | | max | 11.826 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 6.809 | | σ | 1.262 | | min | 5.435 | | max | 9.775 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.004 | | min | 25.665 | | max | 25.677 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 5.519 | | σ | 0.154 | | min | 5.316 | | max | 5.742 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.969 | | max | 25.972 |
| | mean | 4042.375 | | σ | 2011.167 | | min | 1217.000 | | max | 7158.000 |
| | mean | 5.301 | | σ | 0.061 | | min | 5.217 | | max | 5.401 |
|