op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 12.898 | | σ | 0.315 | | min | 12.416 | | max | 13.360 |
|
op=column_set() on indexed, repeat | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 12.983 | | σ | 0.577 | | min | 12.090 | | max | 13.653 |
|
op=table_records(), no indexes | | mean | 41.932 | | σ | 0.001 | | min | 41.929 | | max | 41.933 |
| | mean | 7314.000 | | σ | 0.000 | | min | 7314.000 | | max | 7314.000 |
| | mean | 15.057 | | σ | 0.760 | | min | 13.334 | | max | 15.770 |
|
op=table_records(), repeat | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 12.783 | | σ | 1.870 | | min | 10.933 | | max | 15.496 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.653 | | σ | 0.137 | | min | 27.603 | | max | 27.991 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 8.823 | | σ | 0.211 | | min | 8.421 | | max | 9.052 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 6.828 | | σ | 0.148 | | min | 6.640 | | max | 7.078 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 6.026 | | σ | 0.117 | | min | 5.895 | | max | 6.253 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4155.125 | | σ | 1902.767 | | min | 1553.000 | | max | 7314.000 |
| | mean | 5.856 | | σ | 0.144 | | min | 5.677 | | max | 6.108 |
|