iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 104.094 | | σ | 257.601 | | min | 12.714 | | max | 741.623 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 14.368 | | σ | 2.744 | | min | 13.081 | | max | 21.144 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7210.000 | | σ | 0.000 | | min | 7210.000 | | max | 7210.000 |
| | mean | 14.929 | | σ | 0.909 | | min | 13.321 | | max | 15.761 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7210.000 | | σ | 0.000 | | min | 7210.000 | | max | 7210.000 |
| | mean | 13.724 | | σ | 1.096 | | min | 12.215 | | max | 14.890 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4167.500 | | σ | 1898.698 | | min | 1548.000 | | max | 7210.000 |
| | mean | 13.887 | | σ | 1.521 | | min | 11.368 | | max | 15.699 |
|
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 | 4167.500 | | σ | 1898.698 | | min | 1548.000 | | max | 7210.000 |
| | mean | 9.208 | | σ | 0.425 | | min | 8.550 | | max | 9.796 |
|
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.500 | | σ | 1898.698 | | min | 1548.000 | | max | 7210.000 |
| | mean | 6.556 | | σ | 0.183 | | min | 6.325 | | max | 6.815 |
|
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 | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 6.271 | | σ | 0.504 | | min | 5.910 | | max | 7.494 |
|
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 | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 6.007 | | σ | 0.593 | | min | 5.664 | | max | 7.447 |
|
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 | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 6.057 | | σ | 0.577 | | min | 5.693 | | max | 7.473 |
|
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 | 4284.750 | | σ | 1976.153 | | min | 1548.000 | | max | 7210.000 |
| | mean | 5.921 | | σ | 0.635 | | min | 5.599 | | max | 7.481 |
|
op=column_set() on indexed | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 13.049 | | σ | 0.248 | | min | 12.710 | | max | 13.312 |
|
op=column_set() on indexed, repeat | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 13.176 | | σ | 0.390 | | min | 12.269 | | max | 13.495 |
|
op=table_records(), no indexes | | mean | 41.931 | | σ | 0.001 | | min | 41.929 | | max | 41.932 |
| | mean | 7327.000 | | σ | 0.000 | | min | 7327.000 | | max | 7327.000 |
| | mean | 14.299 | | σ | 0.797 | | min | 12.377 | | max | 14.767 |
|
op=table_records(), repeat | | mean | 41.928 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 12.502 | | σ | 1.674 | | min | 10.924 | | max | 14.542 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.653 | | σ | 0.136 | | min | 27.603 | | max | 27.990 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 9.064 | | σ | 0.358 | | min | 8.600 | | max | 9.558 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.400 | | σ | 0.002 | | min | 26.399 | | max | 26.403 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 7.090 | | σ | 0.094 | | min | 6.928 | | max | 7.262 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.666 | | σ | 0.002 | | min | 25.665 | | max | 25.669 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 6.119 | | σ | 0.142 | | min | 5.955 | | max | 6.390 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.972 |
| | mean | 4156.875 | | σ | 1907.091 | | min | 1556.000 | | max | 7327.000 |
| | mean | 5.787 | | σ | 0.066 | | min | 5.675 | | max | 5.901 |
|