iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4162.375 | | σ | 1888.483 | | min | 1553.000 | | max | 7173.000 |
| | mean | 12.886 | | σ | 0.252 | | min | 12.588 | | max | 13.320 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4279.375 | | σ | 1966.263 | | min | 1553.000 | | max | 7173.000 |
| | mean | 13.899 | | σ | 1.962 | | min | 12.956 | | max | 18.722 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7173.000 | | σ | 0.000 | | min | 7173.000 | | max | 7173.000 |
| | mean | 15.101 | | σ | 0.890 | | min | 13.557 | | max | 15.903 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7173.000 | | σ | 0.000 | | min | 7173.000 | | max | 7173.000 |
| | mean | 13.668 | | σ | 1.405 | | min | 11.252 | | max | 15.596 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4162.375 | | σ | 1888.483 | | min | 1553.000 | | max | 7173.000 |
| | mean | 13.691 | | σ | 1.673 | | min | 11.399 | | max | 15.654 |
|
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 | 4162.375 | | σ | 1888.483 | | min | 1553.000 | | max | 7173.000 |
| | mean | 9.112 | | σ | 0.302 | | min | 8.704 | | max | 9.661 |
|
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 | 4162.375 | | σ | 1888.483 | | min | 1553.000 | | max | 7173.000 |
| | mean | 6.872 | | σ | 0.312 | | min | 6.335 | | max | 7.239 |
|
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 | 4279.375 | | σ | 1966.263 | | min | 1553.000 | | max | 7173.000 |
| | mean | 6.210 | | σ | 0.493 | | min | 5.808 | | max | 7.384 |
|
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 | 4279.375 | | σ | 1966.263 | | min | 1553.000 | | max | 7173.000 |
| | mean | 5.912 | | σ | 0.578 | | min | 5.501 | | max | 7.313 |
|
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 | 4279.375 | | σ | 1966.263 | | min | 1553.000 | | max | 7173.000 |
| | mean | 5.979 | | σ | 0.588 | | min | 5.628 | | max | 7.403 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.003 | | min | 25.967 | | max | 25.975 |
| | mean | 4279.375 | | σ | 1966.263 | | min | 1553.000 | | max | 7173.000 |
| | mean | 5.889 | | σ | 0.601 | | min | 5.542 | | max | 7.348 |
|