op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 12.587 | | σ | 0.321 | | min | 12.070 | | max | 12.948 |
|
op=column_set() on indexed, repeat | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 12.129 | | σ | 0.713 | | min | 11.287 | | max | 13.099 |
|
op=table_records(), no indexes | | mean | 41.932 | | σ | 0.001 | | min | 41.929 | | max | 41.933 |
| | mean | 7301.000 | | σ | 0.000 | | min | 7301.000 | | max | 7301.000 |
| | mean | 15.172 | | σ | 0.566 | | min | 13.866 | | max | 15.653 |
|
op=table_records(), repeat | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 13.221 | | σ | 1.818 | | min | 10.814 | | max | 15.727 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 9.018 | | σ | 0.290 | | min | 8.591 | | max | 9.619 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 6.638 | | σ | 0.331 | | min | 6.207 | | max | 7.065 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.003 | | min | 25.666 | | max | 25.674 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 5.920 | | σ | 0.102 | | min | 5.735 | | max | 6.032 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.968 | | max | 25.974 |
| | mean | 4151.875 | | σ | 1900.254 | | min | 1554.000 | | max | 7301.000 |
| | mean | 5.690 | | σ | 0.212 | | min | 5.342 | | max | 6.012 |
|