iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4171.500 | | σ | 1899.709 | | min | 1552.000 | | max | 7206.000 |
| | mean | 12.888 | | σ | 0.423 | | min | 12.412 | | max | 13.758 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.621 |
| | mean | 4291.750 | | σ | 1979.587 | | min | 1552.000 | | max | 7206.000 |
| | mean | 93.622 | | σ | 228.106 | | min | 12.000 | | max | 658.156 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.933 |
| | mean | 7206.000 | | σ | 0.000 | | min | 7206.000 | | max | 7206.000 |
| | mean | 14.795 | | σ | 1.144 | | min | 12.285 | | max | 15.473 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7206.000 | | σ | 0.000 | | min | 7206.000 | | max | 7206.000 |
| | mean | 13.938 | | σ | 1.035 | | min | 11.663 | | max | 14.796 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4171.500 | | σ | 1899.709 | | min | 1552.000 | | max | 7206.000 |
| | mean | 13.635 | | σ | 1.612 | | min | 11.390 | | max | 15.480 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.003 | | min | 27.603 | | max | 27.611 |
| | mean | 4171.500 | | σ | 1899.709 | | min | 1552.000 | | max | 7206.000 |
| | mean | 9.161 | | σ | 0.268 | | min | 8.722 | | max | 9.515 |
|
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 | 4171.500 | | σ | 1899.709 | | min | 1552.000 | | max | 7206.000 |
| | mean | 6.790 | | σ | 0.254 | | min | 6.487 | | max | 7.114 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.669 |
| | mean | 4291.750 | | σ | 1979.587 | | min | 1552.000 | | max | 7206.000 |
| | mean | 6.376 | | σ | 0.675 | | min | 5.977 | | max | 7.975 |
|
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 | 4291.750 | | σ | 1979.587 | | min | 1552.000 | | max | 7206.000 |
| | mean | 5.930 | | σ | 0.681 | | min | 5.508 | | max | 7.591 |
|
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 | 4291.750 | | σ | 1979.587 | | min | 1552.000 | | max | 7206.000 |
| | mean | 5.878 | | σ | 0.742 | | min | 5.064 | | max | 7.582 |
|
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 | 4291.750 | | σ | 1979.587 | | min | 1552.000 | | max | 7206.000 |
| | mean | 5.697 | | σ | 0.742 | | min | 4.964 | | max | 7.353 |
|