iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.619 |
| | mean | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 97.705 | | σ | 240.523 | | min | 12.558 | | max | 692.968 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.619 |
| | mean | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 12.699 | | σ | 0.705 | | min | 11.860 | | max | 13.800 |
|
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.845 | | σ | 1.114 | | min | 12.759 | | max | 15.922 |
|
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.848 | | σ | 1.077 | | min | 11.785 | | max | 14.850 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4174.875 | | σ | 1903.301 | | min | 1555.000 | | max | 7210.000 |
| | mean | 13.328 | | σ | 1.442 | | min | 11.299 | | max | 15.261 |
|
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 | 4174.875 | | σ | 1903.301 | | min | 1555.000 | | max | 7210.000 |
| | mean | 9.043 | | σ | 0.275 | | min | 8.589 | | max | 9.230 |
|
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 | 4174.875 | | σ | 1903.301 | | min | 1555.000 | | max | 7210.000 |
| | mean | 6.772 | | σ | 0.409 | | min | 6.094 | | max | 7.164 |
|
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 | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 6.137 | | σ | 0.479 | | min | 5.779 | | max | 7.278 |
|
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 | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 5.849 | | σ | 0.643 | | min | 5.303 | | max | 7.383 |
|
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 | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 5.846 | | σ | 0.608 | | min | 5.410 | | max | 7.331 |
|
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 | 4290.875 | | σ | 1980.722 | | min | 1555.000 | | max | 7210.000 |
| | mean | 5.714 | | σ | 0.620 | | min | 5.041 | | max | 7.171 |
|