iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4167.000 | | σ | 1897.049 | | min | 1551.000 | | max | 7201.000 |
| | mean | 12.773 | | σ | 0.354 | | min | 12.286 | | max | 13.421 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.000 | | σ | 1976.567 | | min | 1551.000 | | max | 7201.000 |
| | mean | 104.992 | | σ | 260.719 | | min | 11.958 | | max | 750.236 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.001 | | min | 41.928 | | max | 41.932 |
| | mean | 7201.000 | | σ | 0.000 | | min | 7201.000 | | max | 7201.000 |
| | mean | 14.796 | | σ | 1.400 | | min | 11.760 | | max | 15.960 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7201.000 | | σ | 0.000 | | min | 7201.000 | | max | 7201.000 |
| | mean | 13.161 | | σ | 1.294 | | min | 11.361 | | max | 14.649 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4167.000 | | σ | 1897.049 | | min | 1551.000 | | max | 7201.000 |
| | mean | 13.308 | | σ | 1.687 | | min | 11.018 | | max | 15.464 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.604 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4167.000 | | σ | 1897.049 | | min | 1551.000 | | max | 7201.000 |
| | mean | 8.952 | | σ | 0.301 | | min | 8.360 | | max | 9.272 |
|
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 | 4167.000 | | σ | 1897.049 | | min | 1551.000 | | max | 7201.000 |
| | mean | 6.925 | | σ | 0.136 | | min | 6.700 | | max | 7.078 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4287.000 | | σ | 1976.567 | | min | 1551.000 | | max | 7201.000 |
| | mean | 6.223 | | σ | 0.701 | | min | 5.763 | | max | 7.918 |
|
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 | 4287.000 | | σ | 1976.567 | | min | 1551.000 | | max | 7201.000 |
| | mean | 5.830 | | σ | 0.662 | | min | 5.504 | | max | 7.442 |
|
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 | 4287.000 | | σ | 1976.567 | | min | 1551.000 | | max | 7201.000 |
| | mean | 5.805 | | σ | 0.475 | | min | 5.542 | | max | 6.966 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.001 | | min | 25.967 | | max | 25.971 |
| | mean | 4287.000 | | σ | 1976.567 | | min | 1551.000 | | max | 7201.000 |
| | mean | 5.662 | | σ | 0.463 | | min | 5.410 | | max | 6.801 |
|