iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 92.255 | | σ | 224.980 | | min | 12.436 | | max | 649.051 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 13.108 | | σ | 0.549 | | min | 11.947 | | max | 13.880 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 15.111 | | σ | 0.998 | | min | 12.932 | | max | 15.947 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7208.000 | | σ | 0.000 | | min | 7208.000 | | max | 7208.000 |
| | mean | 13.712 | | σ | 1.082 | | min | 11.972 | | max | 14.861 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.932 |
| | mean | 4168.750 | | σ | 1902.750 | | min | 1549.000 | | max | 7208.000 |
| | mean | 13.709 | | σ | 1.570 | | min | 11.596 | | max | 15.358 |
|
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 | 4168.750 | | σ | 1902.750 | | min | 1549.000 | | max | 7208.000 |
| | mean | 8.941 | | σ | 0.480 | | min | 8.228 | | max | 9.804 |
|
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 | 4168.750 | | σ | 1902.750 | | min | 1549.000 | | max | 7208.000 |
| | mean | 6.884 | | σ | 0.285 | | min | 6.459 | | max | 7.317 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.664 | | max | 25.670 |
| | mean | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 6.016 | | σ | 0.151 | | min | 5.754 | | max | 6.191 |
|
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 | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 5.638 | | σ | 0.152 | | min | 5.396 | | max | 5.819 |
|
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 | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 5.698 | | σ | 0.118 | | min | 5.501 | | max | 5.845 |
|
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 | 4285.750 | | σ | 1980.551 | | min | 1549.000 | | max | 7208.000 |
| | mean | 5.806 | | σ | 0.622 | | min | 5.479 | | max | 7.328 |
|