iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 47.650 | | σ | 98.337 | | min | 12.600 | | max | 291.022 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 12.801 | | σ | 0.665 | | min | 11.957 | | max | 13.916 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 15.083 | | σ | 0.998 | | min | 13.064 | | max | 15.788 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 13.489 | | σ | 1.179 | | min | 11.077 | | max | 14.668 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.375 | | σ | 1904.770 | | min | 1549.000 | | max | 7211.000 |
| | mean | 13.963 | | σ | 1.487 | | min | 11.039 | | max | 15.166 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4170.375 | | σ | 1904.770 | | min | 1549.000 | | max | 7211.000 |
| | mean | 8.840 | | σ | 0.191 | | min | 8.498 | | max | 9.036 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.001 | | min | 26.399 | | max | 26.403 |
| | mean | 4170.375 | | σ | 1904.770 | | min | 1549.000 | | max | 7211.000 |
| | mean | 6.952 | | σ | 0.107 | | min | 6.822 | | max | 7.081 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.668 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 6.116 | | σ | 0.148 | | min | 5.888 | | max | 6.371 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.661 | | σ | 0.002 | | min | 25.659 | | max | 25.663 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 5.645 | | σ | 0.048 | | min | 5.592 | | max | 5.750 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 5.690 | | σ | 0.087 | | min | 5.580 | | max | 5.829 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4285.750 | | σ | 1981.679 | | min | 1549.000 | | max | 7211.000 |
| | mean | 5.611 | | σ | 0.109 | | min | 5.475 | | max | 5.791 |
|