iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4287.000 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 99.378 | | σ | 244.817 | | min | 12.509 | | max | 705.270 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4287.000 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 13.643 | | σ | 3.092 | | min | 11.871 | | max | 21.119 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7211.000 | | σ | 0.000 | | min | 7211.000 | | max | 7211.000 |
| | mean | 15.056 | | σ | 0.903 | | min | 13.320 | | max | 16.073 |
|
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.811 | | σ | 1.122 | | min | 11.123 | | max | 14.447 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4170.625 | | σ | 1903.176 | | min | 1552.000 | | max | 7211.000 |
| | mean | 13.706 | | σ | 1.671 | | min | 11.317 | | max | 15.307 |
|
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 | 4170.625 | | σ | 1903.176 | | min | 1552.000 | | max | 7211.000 |
| | mean | 8.989 | | σ | 0.399 | | min | 8.172 | | max | 9.455 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4170.625 | | σ | 1903.176 | | min | 1552.000 | | max | 7211.000 |
| | mean | 6.856 | | σ | 0.225 | | min | 6.519 | | max | 7.151 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.668 |
| | mean | 4287.000 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 6.140 | | σ | 0.575 | | min | 5.728 | | max | 7.526 |
|
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 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 5.807 | | σ | 0.615 | | min | 5.337 | | max | 7.264 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4287.000 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 5.903 | | σ | 0.651 | | min | 5.456 | | max | 7.470 |
|
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 | | σ | 1980.549 | | min | 1552.000 | | max | 7211.000 |
| | mean | 5.711 | | σ | 0.649 | | min | 5.137 | | max | 7.267 |
|