iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4164.000 | | σ | 1895.945 | | min | 1548.000 | | max | 7196.000 |
| | mean | 12.673 | | σ | 0.308 | | min | 12.175 | | max | 13.224 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4283.875 | | σ | 1975.396 | | min | 1548.000 | | max | 7196.000 |
| | mean | 86.304 | | σ | 206.870 | | min | 12.623 | | max | 598.280 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7196.000 | | σ | 0.000 | | min | 7196.000 | | max | 7196.000 |
| | mean | 14.863 | | σ | 1.219 | | min | 12.255 | | max | 16.241 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7196.000 | | σ | 0.000 | | min | 7196.000 | | max | 7196.000 |
| | mean | 13.607 | | σ | 1.162 | | min | 11.791 | | max | 15.170 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4164.000 | | σ | 1895.945 | | min | 1548.000 | | max | 7196.000 |
| | mean | 13.616 | | σ | 1.613 | | min | 11.002 | | max | 15.664 |
|
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 | 4164.000 | | σ | 1895.945 | | min | 1548.000 | | max | 7196.000 |
| | mean | 9.199 | | σ | 0.404 | | min | 8.558 | | max | 9.728 |
|
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 | 4164.000 | | σ | 1895.945 | | min | 1548.000 | | max | 7196.000 |
| | mean | 6.766 | | σ | 0.333 | | min | 6.235 | | max | 7.231 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.667 | | σ | 0.002 | | min | 25.665 | | max | 25.670 |
| | mean | 4283.875 | | σ | 1975.396 | | min | 1548.000 | | max | 7196.000 |
| | mean | 6.326 | | σ | 0.836 | | min | 5.848 | | max | 8.375 |
|
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 | 4283.875 | | σ | 1975.396 | | min | 1548.000 | | max | 7196.000 |
| | mean | 5.787 | | σ | 0.575 | | min | 5.358 | | max | 7.184 |
|
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 | 4283.875 | | σ | 1975.396 | | min | 1548.000 | | max | 7196.000 |
| | mean | 5.879 | | σ | 0.538 | | min | 5.474 | | max | 7.186 |
|
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 | 4283.875 | | σ | 1975.396 | | min | 1548.000 | | max | 7196.000 |
| | mean | 5.737 | | σ | 0.550 | | min | 5.368 | | max | 7.082 |
|