iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.604 | | σ | 0.002 | | min | 36.603 | | max | 36.607 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 71.392 | | σ | 166.180 | | min | 12.460 | | max | 482.665 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.604 | | σ | 0.002 | | min | 36.603 | | max | 36.607 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 13.134 | | σ | 1.233 | | min | 12.045 | | max | 16.014 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.922 | | σ | 0.002 | | min | 41.920 | | max | 41.924 |
| | mean | 7207.000 | | σ | 0.000 | | min | 7207.000 | | max | 7207.000 |
| | mean | 14.806 | | σ | 0.891 | | min | 12.769 | | max | 15.466 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.921 | | σ | 0.002 | | min | 41.919 | | max | 41.924 |
| | mean | 7207.000 | | σ | 0.000 | | min | 7207.000 | | max | 7207.000 |
| | mean | 13.438 | | σ | 0.990 | | min | 12.005 | | max | 14.300 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.920 | | σ | 0.002 | | min | 41.919 | | max | 41.923 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 13.331 | | σ | 1.647 | | min | 10.782 | | max | 15.452 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.582 | | σ | 0.002 | | min | 27.581 | | max | 27.585 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 8.918 | | σ | 0.303 | | min | 8.444 | | max | 9.273 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records(), repeat rows=200000 | | mean | 26.378 | | σ | 0.002 | | min | 26.377 | | max | 26.381 |
| | mean | 4166.500 | | σ | 1902.413 | | min | 1546.000 | | max | 7207.000 |
| | mean | 6.966 | | σ | 0.172 | | min | 6.628 | | max | 7.173 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.647 | | σ | 0.002 | | min | 25.646 | | max | 25.650 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 6.019 | | σ | 0.174 | | min | 5.782 | | max | 6.310 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed, repeat rows=200000 | | mean | 25.642 | | σ | 0.002 | | min | 25.640 | | max | 25.644 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.610 | | σ | 0.046 | | min | 5.535 | | max | 5.655 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed) rows=200000 | | mean | 25.945 | | σ | 0.002 | | min | 25.944 | | max | 25.949 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.650 | | σ | 0.057 | | min | 5.563 | | max | 5.724 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.945 | | σ | 0.002 | | min | 25.944 | | max | 25.948 |
| | mean | 4282.875 | | σ | 1979.690 | | min | 1546.000 | | max | 7207.000 |
| | mean | 5.654 | | σ | 0.260 | | min | 5.513 | | max | 6.291 |
|
op=column_set() on indexed | | mean | 36.604 | | σ | 0.000 | | min | 36.604 | | max | 36.605 |
| | mean | 4411.500 | | σ | 2198.847 | | min | 1482.000 | | max | 7333.000 |
| | mean | 12.997 | | σ | 2.021 | | min | 11.895 | | max | 17.844 |
|
op=column_set() on indexed, repeat | | mean | 36.604 | | σ | 0.000 | | min | 36.604 | | max | 36.605 |
| | mean | 4411.500 | | σ | 2198.847 | | min | 1482.000 | | max | 7333.000 |
| | mean | 13.244 | | σ | 2.178 | | min | 11.498 | | max | 18.413 |
|
op=table_records(), no indexes | | mean | 41.940 | | σ | 0.002 | | min | 41.938 | | max | 41.942 |
| | mean | 7341.250 | | σ | 5.092 | | min | 7333.000 | | max | 7344.000 |
| | mean | 11.090 | | σ | 0.207 | | min | 10.775 | | max | 11.345 |
|
op=table_records(), repeat | | mean | 41.925 | | σ | 0.000 | | min | 41.924 | | max | 41.925 |
| | mean | 4191.750 | | σ | 1937.478 | | min | 1482.000 | | max | 7333.000 |
| | mean | 11.838 | | σ | 1.535 | | min | 10.826 | | max | 15.507 |
|
op=vertical_lookup_list() on indexed, after table_records() | | mean | 27.633 | | σ | 0.136 | | min | 27.584 | | max | 27.971 |
| | mean | 4191.750 | | σ | 1937.478 | | min | 1482.000 | | max | 7333.000 |
| | mean | 8.940 | | σ | 1.162 | | min | 7.918 | | max | 11.709 |
|
op=vertical_lookup_list() on indexed, after table_records(), repeat | | mean | 26.384 | | σ | 0.000 | | min | 26.384 | | max | 26.384 |
| | mean | 4191.750 | | σ | 1937.478 | | min | 1482.000 | | max | 7333.000 |
| | mean | 6.750 | | σ | 1.026 | | min | 5.894 | | max | 9.167 |
|
op=vertical_lookup_row_list() on 2 indexed | | mean | 25.662 | | σ | 0.004 | | min | 25.661 | | max | 25.673 |
| | mean | 4589.375 | | σ | 2232.160 | | min | 1482.000 | | max | 7333.000 |
| | mean | 6.658 | | σ | 1.105 | | min | 5.892 | | max | 9.174 |
|
op=vertical_lookup_row_list() on 3 (1 unindexed) | | mean | 25.961 | | σ | 0.001 | | min | 25.960 | | max | 25.962 |
| | mean | 4589.375 | | σ | 2232.160 | | min | 1482.000 | | max | 7333.000 |
| | mean | 6.232 | | σ | 0.619 | | min | 5.819 | | max | 7.391 |
|