iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 66.543 | | σ | 151.910 | | min | 12.336 | | max | 442.499 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 12.904 | | σ | 1.292 | | min | 11.828 | | max | 15.471 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7205.000 | | σ | 0.000 | | min | 7205.000 | | max | 7205.000 |
| | mean | 15.093 | | σ | 1.214 | | min | 12.641 | | max | 16.245 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7205.000 | | σ | 0.000 | | min | 7205.000 | | max | 7205.000 |
| | mean | 13.818 | | σ | 0.960 | | min | 11.745 | | max | 14.813 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4164.750 | | σ | 1897.997 | | min | 1549.000 | | max | 7205.000 |
| | mean | 13.865 | | σ | 1.692 | | min | 11.088 | | max | 15.453 |
|
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 | 4164.750 | | σ | 1897.997 | | min | 1549.000 | | max | 7205.000 |
| | mean | 9.118 | | σ | 0.267 | | min | 8.622 | | max | 9.434 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.401 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4164.750 | | σ | 1897.997 | | min | 1549.000 | | max | 7205.000 |
| | mean | 6.505 | | σ | 0.506 | | min | 5.646 | | max | 7.386 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 6.100 | | σ | 0.164 | | min | 5.900 | | max | 6.400 |
|
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 | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 5.745 | | σ | 0.065 | | min | 5.682 | | max | 5.857 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.969 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 5.884 | | σ | 0.087 | | min | 5.747 | | max | 5.996 |
|
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 | 4281.375 | | σ | 1975.180 | | min | 1549.000 | | max | 7205.000 |
| | mean | 5.705 | | σ | 0.190 | | min | 5.258 | | max | 5.865 |
|