op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 12.811 | | σ | 0.269 | | min | 12.405 | | max | 13.270 |
|
op=column_set() on indexed, repeat | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 12.958 | | σ | 0.601 | | min | 11.775 | | max | 13.507 |
|
op=table_records(), no indexes | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7153.000 | | σ | 0.000 | | min | 7153.000 | | max | 7153.000 |
| | mean | 15.266 | | σ | 0.202 | | min | 15.001 | | max | 15.569 |
|
op=table_records(), repeat | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 14.795 | | σ | 1.344 | | min | 11.788 | | max | 16.030 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.654 | | σ | 0.136 | | min | 27.604 | | max | 27.991 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 10.019 | | σ | 1.751 | | min | 8.518 | | max | 12.912 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.401 | | σ | 0.002 | | min | 26.400 | | max | 26.404 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 7.707 | | σ | 1.648 | | min | 6.417 | | max | 10.480 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.668 | | σ | 0.004 | | min | 25.665 | | max | 25.678 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 6.042 | | σ | 0.199 | | min | 5.675 | | max | 6.353 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.970 | | σ | 0.002 | | min | 25.969 | | max | 25.972 |
| | mean | 4043.125 | | σ | 2010.184 | | min | 1219.000 | | max | 7153.000 |
| | mean | 5.895 | | σ | 0.154 | | min | 5.672 | | max | 6.150 |
|