op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 12.812 | | σ | 0.362 | | min | 12.390 | | max | 13.459 |
|
op=column_set() on indexed, repeat | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 12.600 | | σ | 0.529 | | min | 12.015 | | max | 13.320 |
|
op=table_records(), no indexes | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7154.000 | | σ | 0.000 | | min | 7154.000 | | max | 7154.000 |
| | mean | 15.466 | | σ | 0.311 | | min | 15.069 | | max | 15.964 |
|
op=table_records(), repeat | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 14.191 | | σ | 1.655 | | min | 11.560 | | max | 15.566 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 9.507 | | σ | 0.917 | | min | 8.458 | | max | 11.230 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 6.706 | | σ | 0.765 | | min | 5.845 | | max | 8.289 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.004 | | min | 25.665 | | max | 25.678 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 6.065 | | σ | 0.126 | | min | 5.931 | | max | 6.294 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.969 | | max | 25.972 |
| | mean | 4044.250 | | σ | 2011.085 | | min | 1216.000 | | max | 7154.000 |
| | mean | 5.781 | | σ | 0.198 | | min | 5.420 | | max | 6.041 |
|