iterations=8 operation_display=column_set() on indexed rows=200000 | | mean | 36.617 | | σ | 0.002 | | min | 36.615 | | max | 36.620 |
| | mean | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 71.472 | | σ | 166.443 | | min | 12.300 | | max | 483.397 |
|
iterations=8 operation_display=column_set() on indexed, repeat rows=200000 | | mean | 36.618 | | σ | 0.002 | | min | 36.616 | | max | 36.620 |
| | mean | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 13.235 | | σ | 1.306 | | min | 11.851 | | max | 16.175 |
|
iterations=8 operation_display=table_records(), no indexes rows=200000 | | mean | 41.930 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7206.000 | | σ | 0.000 | | min | 7206.000 | | max | 7206.000 |
| | mean | 14.816 | | σ | 1.200 | | min | 12.178 | | max | 15.594 |
|
iterations=8 operation_display=table_records(), no indexes, repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.928 | | max | 41.932 |
| | mean | 7206.000 | | σ | 0.000 | | min | 7206.000 | | max | 7206.000 |
| | mean | 13.460 | | σ | 1.392 | | min | 11.717 | | max | 15.349 |
|
iterations=8 operation_display=table_records(), repeat rows=200000 | | mean | 41.929 | | σ | 0.002 | | min | 41.927 | | max | 41.931 |
| | mean | 4168.125 | | σ | 1898.854 | | min | 1551.000 | | max | 7206.000 |
| | mean | 13.645 | | σ | 1.758 | | min | 11.195 | | max | 15.401 |
|
iterations=8 operation_display=vertical_lookup_list() on indexed, after table_records() rows=200000 | | mean | 27.605 | | σ | 0.002 | | min | 27.603 | | max | 27.607 |
| | mean | 4168.125 | | σ | 1898.854 | | min | 1551.000 | | max | 7206.000 |
| | mean | 9.300 | | σ | 0.326 | | min | 8.896 | | max | 9.700 |
|
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.125 | | σ | 1898.854 | | min | 1551.000 | | max | 7206.000 |
| | mean | 6.608 | | σ | 0.315 | | min | 6.067 | | max | 7.104 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 2 indexed rows=200000 | | mean | 25.666 | | σ | 0.002 | | min | 25.664 | | max | 25.668 |
| | mean | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 6.050 | | σ | 0.169 | | min | 5.704 | | max | 6.245 |
|
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 | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 5.593 | | σ | 0.246 | | min | 5.228 | | max | 5.817 |
|
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 | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 5.713 | | σ | 0.155 | | min | 5.497 | | max | 5.934 |
|
iterations=8 operation_display=vertical_lookup_row_list() on 3 (1 unindexed), repeat rows=200000 | | mean | 25.968 | | σ | 0.002 | | min | 25.967 | | max | 25.971 |
| | mean | 4284.875 | | σ | 1976.157 | | min | 1551.000 | | max | 7206.000 |
| | mean | 5.550 | | σ | 0.205 | | min | 5.141 | | max | 5.722 |
|