iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 111.602 | | σ | 279.975 | | min | 12.251 | | max | 804.505 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 14.346 | | σ | 4.178 | | min | 11.901 | | max | 24.633 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 14.894 | | σ | 0.832 | | min | 13.373 | | max | 15.494 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7214.000 | | σ | 0.000 | | min | 7214.000 | | max | 7214.000 |
| | mean | 13.684 | | σ | 0.773 | | min | 12.419 | | max | 14.630 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4171.125 | | σ | 1902.588 | | min | 1550.000 | | max | 7214.000 |
| | mean | 13.007 | | σ | 1.614 | | min | 10.737 | | max | 14.495 |
|
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 | 4171.125 | | σ | 1902.588 | | min | 1550.000 | | max | 7214.000 |
| | mean | 8.682 | | σ | 0.326 | | min | 8.142 | | max | 9.128 |
|
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 | 4171.125 | | σ | 1902.588 | | min | 1550.000 | | max | 7214.000 |
| | mean | 6.633 | | σ | 0.160 | | min | 6.287 | | max | 6.791 |
|
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 | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 6.342 | | σ | 0.956 | | min | 5.833 | | max | 8.699 |
|
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 | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 5.800 | | σ | 1.084 | | min | 5.209 | | max | 8.464 |
|
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 | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 5.796 | | σ | 1.093 | | min | 5.211 | | max | 8.481 |
|
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 | 4288.125 | | σ | 1980.169 | | min | 1550.000 | | max | 7214.000 |
| | mean | 5.586 | | σ | 1.077 | | min | 5.058 | | max | 8.234 |
|