op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 12.862 | | σ | 0.318 | | min | 12.436 | | max | 13.459 |
|
op=column_set() on indexed, repeat | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 12.765 | | σ | 0.637 | | min | 11.636 | | max | 13.375 |
|
op=table_records(), no indexes | | mean | 41.931 | | σ | 0.001 | | min | 41.928 | | max | 41.933 |
| | mean | 7321.000 | | σ | 0.000 | | min | 7321.000 | | max | 7321.000 |
| | mean | 15.050 | | σ | 0.897 | | min | 12.886 | | max | 15.658 |
|
op=table_records(), repeat | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 12.600 | | σ | 1.805 | | min | 10.799 | | max | 14.945 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.653 | | σ | 0.137 | | min | 27.603 | | max | 27.991 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 8.852 | | σ | 0.390 | | min | 8.254 | | max | 9.479 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 6.852 | | σ | 0.134 | | min | 6.658 | | max | 7.069 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 6.076 | | σ | 0.165 | | min | 5.831 | | max | 6.311 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4158.875 | | σ | 1902.159 | | min | 1556.000 | | max | 7321.000 |
| | mean | 5.811 | | σ | 0.101 | | min | 5.682 | | max | 5.986 |
|